Please tell me how to remove a limited number of rows from a table in MySQL?
I need to delete 100 rows from a table.
I tried this:
DELETE FROM b_iblock_section WHERE id IN (SELECT ID FROM b_iblock_section WHERE IBLOCK_ID=4 LIMIT 0,100);
But get the error
#1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
Thanks in advance