Delete many rows from a table using ID in Mysql - Cacher Snippet

1/28/2015 - 8:11 PM

Delete many rows from a table using ID in Mysql

Delete many rows from a table using ID in Mysql

delete-multiple-rows.sql

-- The best way is to use IN statement :
DELETE from tablename WHERE id IN (1,2,3,...,254);

-- You can also use BETWEEN if you have consecutive IDs :
DELETE from tablename WHERE id BETWEEN 1 AND 254;

/* You can of course limit for some IDs using other WHERE clause */ :
DELETE from tablename WHERE id BETWEEN 1 AND 254 AND id<>10;