MySQL Error? Where the syntax mistake?

Question

Tried thus query with "SELECT *" instead of "DELETE FROM" and it worked perfectly.

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 your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't1 WHERE EXISTS (SELECT 1 from 80dage_garmin_track` t2 WHERE t1.Le' at line 1

Thilo · Accepted Answer · 2010-10-13 09:22:52Z

3

MySQL does not allow all kinds of sub selects in the WHERE clause of DELETE, see this thread. Yours may (or may not) be fine, if you drop the table alias (t1), which is also not allowed for DELETE.

answered Oct 13, 2010 at 9:22

Thilo

264k107 gold badges527 silver badges674 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

kevchadders Over a year ago

+1 for... drop the table alias (t1), which is also not allowed for DELETE

EastDane Over a year ago

I did a SELECT of the query and seleced all rows in phpmyadmin and deleted them. Worked out well.

Collectives™ on Stack Overflow

MySQL Error? Where the syntax mistake?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related