Database: SQL: Deleting Rows

Deleting Rows

DELETE FROM table WHERE search-condition

Deletes all rows for which the search condition is true.

DELETE FROM table

Deletes all rows from the table, but doesn't DROP the table.