MySQL error? Where is the syntax error?

I tried to query using "SELECT *" instead of "DELETE FROM", and it worked fine.

DELETE FROM  `80dage_garmin_track` t1 WHERE EXISTS (

SELECT 1 
FROM  `80dage_garmin_track` t2
WHERE t1.Length = t2.Length
AND t1.Time = t2.Time
AND t1.idgarmin_track > t2.idgarmin_track
)

MySQL error: . # 1064 - You have an error in the SQL syntax; check the manual that matches your MySQL server version for the correct syntax to use next to 't1 WHERE EXISTS (SELECT 1 of 80dage_garmin_track` t2 WHERE t1.Le' on line 1

+3
source share
1 answer

MySQL WHERE DELETE, . . (t1), DELETE, ( ).

+3

Source: https://habr.com/ru/post/1769303/


All Articles