DELETE FROM table1 / TRUNCATE table1 DELETE FROM table1 WHERE condition DELETE FROM table1, table2 WHERE table1.id1 = table2.id2 AND condition