Skip to content

mysql delete with subquery using a limit

So, you are want to delete entries by using a subquery and the limit and all you get back is something like the following:

This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
The solution is a little bit tricky and costs a bit performance but it is working, try the following:
DELETE FROM `my_table` WHERE `my_table`.`id` IN ( SELECT * FROM ( SELECT `my_other_table`.`id` FROM `my_other_table` WHERE `my_other_table`.`condition` = 'My condition' LIMIT 0, 100 ) as deleteTable);


No Trackbacks


Display comments as Linear | Threaded

No comments

Add Comment

E-Mail addresses will not be displayed and will only be used for E-Mail notifications.
To leave a comment you must approve it via e-mail, which will be sent to your address after submission.

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.

Markdown format allowed
Form options