Mysql – OUT parameter needs INPUT
I am doing a course on SQL on MYSQL workbench. In the course I had an exercise in which I had to take an IN parameter value and save as an OUT parameter value for further use. I came up…
ERROR: You can't specify target table 'wpp' for update in FROM clause – Mysql
I am trying to UPDATE table value where meta key value _stock_status and id value list of ids, but i got an error (You can't specify target table 'wpp' for update in FROM clause). please advise here is my query…
Can't connect to mysql service on kuberenetes through workbench – Docker
I am using Minikube and here is my configuration: kubectl describe deployment mysql the output: Name: mysql Namespace: default CreationTimestamp: Sat, 12 Nov 2022 02:20:54 +0200 Labels: <none> Annotations: deployment.kubernetes.io/revision: 1 Selector: app=mysql Replicas: 1 desired | 1 updated |…
MySQL case query only getting one result
EDITED: I am trying to CASE a query from my table when a result meets 2 sets of criteria (Flight Time & Tail Number), but I am receiving the wrong result. I only started SQL a few weeks ago for…
Mysql – Need query result that doesn't start and end with "A" or "a" letter
I am trying to write a query that returns list of customer names that do not start or end with letter "A" (either in upper case or lower case). Following is my query, SELECT * FROM Customers WHERE CustomerName IN…
Mysql – Find the customer_IDs of the customers who
My code is: CREATE TABLE `table_a` ( `id` INT NOT NULL AUTO_INCREMENT, `value` varchar(255), PRIMARY KEY (`id`) ) ENGINE=InnoDB; CREATE TABLE `table_b` LIKE `table_a`; INSERT INTO table_a VALUES (1, 'A'), (2, 'B'), (3, 'B'); INSERT INTO table_b VALUES (1, 'B');…
Mysql – Calculating difference between consecutive rows, then finding top 3 IDs with highest count of negative differences SQL
I'm having a lot of difficulty writing an SQL query. I need to compute the difference between consecutive rows for 4 different regions across different years, then subsequently display only the top 3 regions with the highest count of negative…
Compare SQL Server database with MySQL database
I have migrated my existing SQL server database to MySQL server database using MySQL workbench Migration Wizard. Because these are two different database servers, I want to ensure there is no data loss along with stored procedures, triggers, and views,…
Mysql – How do I use a WHERE clause on a user-defined variable from a CASE WHEN?
SELECT #Opportunity Details o.Id AS 'Opportunity ID', o.Name As 'Opportunity', o.Project_Assigned__c AS 'PM Assign Date', CASE WHEN o.StageName IN ('Best Case','Commit','Committed','Discover and Assess','Pipeline','Probable','Sales Qualification','Upside') THEN 'Pre-Sales' WHEN o.StageName IN ('Omit - Closed','Omit from Forecast','Omit-Closed','Omitted') THEN 'Omit' WHEN o.StageName IN ('Rejected','Lost','Cancelled')…
How can I convert a varchar into a date in MySQL Workbench?
Probably it's super simple but i've been stuck some hours on this. I have a column called "Publish_Date" which is a varchar, but my date shows like this: 17.01.11 (year.day.month) and I want to convert it to a date (at…