Deleting multiple rows in mysql (solved)
Posted: Thu Nov 10, 2005 1:15 pm
what would be the syntax for deleting more than one row... would you have to just do multiple queries like this...
Or is there some other way that would be better?
Code: Select all
DELETE FROM table WHERE id = 3;
DELETE FROM table WHERE id = 6;
DELETE FROM table WHERE id = 19;
DELETE FROM table WHERE id = 36;