Best approach to delete and update a big amout of rows in MySQL
Simple and easy:

DELETE FROM tbl
    WHERE id IN ( 11,22,... 999 );


But...  If you have thousands of ids to delete, let's discuss where they the ids came from.  If they are sitting in another table, or can be found via some form of SELECT, then a "Multi-table DELETE" is probably a better way to do it.

Or if you know that the rows are consecutive in some way, then there may be other options.  For example, to delete "old" rows:

DELETE FROM tbl
    WHERE datetime &lt; NOW() - INTERVAL 7 DAY;


will delete rows older than a week.