Page 1 of 1

Deleting multiple rows in mysql (solved)

Posted: Thu Nov 10, 2005 1:15 pm
by Luke
what would be the syntax for deleting more than one row... would you have to just do multiple queries like this...

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;
Or is there some other way that would be better?

Posted: Thu Nov 10, 2005 1:23 pm
by hawleyjr

Code: Select all

DELETE FROM table WHERE id = 3 or id = 6 or id = 19 or id = 36

Posted: Thu Nov 10, 2005 1:35 pm
by redmonkey

Code: Select all

DELETE FROM table WHERE id IN (3, 6, 19, 36)

Posted: Thu Nov 10, 2005 1:36 pm
by Luke
Thanks