How To Delete Multiple Rows from a Table?

Answer 1

You can delete multiple rows from a table in the same way as deleting a single row, except that the WHERE clause will match multiple rows. The tutorial exercise below deletes 3 rows from the temp_links table:

SELECT * FROM temp_links WHERE id >= 250;
   ID URL                   NOTES        COUNTS CREATED
----- --------------------- ----------- ------- ---------
 1250 Retail Sales.com      Wrong URL       500 07-MAY-06
 1260 Recruiting.com        Wrong URL       520 07-MAY-06
 1270 Payroll.com           Wrong URL       540 07-MAY-06

DELETE FROM temp_links WHERE id >= 250;
3 row deleted.

SELECT * FROM temp_links WHERE id >= 250;
no rows selected