1.Previous
3.Next

than 80.DELETE FROM trees WHERE height < 80;

Delete all rows from mytable:DELETE FROM mytable;

Delete rows from mytable using a subquery in the where condition:DELETE FROM mytable WHERE id IN ( SELECT id FROM mytable2 );

Delete rows from mytable using a list of values:DELETE FROM mytable WHERE id IN ( value1, value2, value3, value4, value5 );

1.Previous
3.Next