I'm not clear how to search for this, if there's a duplicate feel free to point me to it. I'm wondering if there's a way to tell mysql that something will be sorted before filtering so that it can perform…
This is my table Customer (custid, custName, custAddress, custPhone) My Question is List the pair of customers who share the same phone number. I just created the following table:
I have a MySQL table called names with a column names name. This column has the following values: Beacher Ackley Addison Caldwell Cameron Alcott Carling Beardsley Beldon I want to get, alphabetically sorted, the value of every first letter. Alphabetically…
I'm using MySQL 8.0 Table NameL: sc (score) Columns: student_id, course_id, score Some dummy data: create table sc(SId varchar(10),CId varchar(10),score decimal(18,1)); insert into sc values('01' , '01' , 80); insert into sc values('01' , '02' , 90); insert into sc…
I have the following method in my Spring Boot app in my Repository: @Query(""" SELECT tw FROM TW tw INNER JOIN tw.docks d // TW entity has list of docks WHERE d.id = :dockId AND tw.status <> 'DELETED' """) List<TW>…
This line of code is no working, and I cannot for the life of me figure out what is wrong with it. INSERT INTO teacher (email,password,admin) VALUES ([email protected],d%6AsQPq7y,1); this wont run and says the error is near the end of…
I have three tables which look like this (simplified) "plants" Table ID (PK, AI) | botanicalName | quickCode 1 | Monstera adansonii | 1234567 2 | Aloe Vera | 1233456 "commonNames" Table ID (PK, AI) | plantsID | commonName 1…
I am writing code to insert values from CSV files to MySQL DB. one of the SQL columns is DateTime. I get the value created from CSV and its this: 07/07/10 08:08 Timestamp sqlTimestampCreated = Timestamp.valueOf(String.valueOf(created)); statement.setTimestamp(6, sqlTimestampCreated); how to…
I am using tableau for a dashboard that pulls data in from a MySQL database. It works perfectly but the query takes too long to execute. The data is limited to the previous 2 years and the most recent Saturday…
I'm attempting to create a single query that UPDDATES another table where the SUBQUERY/ DERIVED-QUERY uses two functions, GROUP BY and GROUP_CONCAT(). I'm able to get my desired output if I utilize a intermediate temporary table to store the "grouped/…