Delete many rows from a table using id in Mysql
mysql, sql, sql-delete
Solution
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;
Problem
I am a Linux admin with only basic knowledge in Mysql Queries I want to delete many table entries which are ip address from my table using id, currently i am using ``` DELETE from tablename where id=1; DELETE from tablename where id=2; ``` but i have to delete 254 entries,so this method is going to take hours,how can i tell mysql to delete rows that i specify,coz i want to skip deleting some entries out of this 254. Deleting whole table and importing needed entries is not an option.