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
source
share