Hello,
I want to execute a simple request SQL on the MySql shell,
On DB2 and solid this line work perfectly, but under mySql i get an error.
This is the error:
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'exists (SELECT Table_2.Tab1ID FROM Rdv WHERE Table_2.Tab1ID = 1
This is the line to execute:
DELETE FROM Table_1 WHERE ((Table_1.ID = 123456) AND not exists (SELECT Table_2.Tab1ID FROM Rdv WHERE Table_2.Tab1ID = 123456));
Anyone have an idea of the source of the problem??
Thank you,
I want to execute a simple request SQL on the MySql shell,
On DB2 and solid this line work perfectly, but under mySql i get an error.
This is the error:
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'exists (SELECT Table_2.Tab1ID FROM Rdv WHERE Table_2.Tab1ID = 1
This is the line to execute:
DELETE FROM Table_1 WHERE ((Table_1.ID = 123456) AND not exists (SELECT Table_2.Tab1ID FROM Rdv WHERE Table_2.Tab1ID = 123456));
Anyone have an idea of the source of the problem??
Thank you,
Comment