DELETE

Remove records from a table

Synopsis:

 DELETE FROM [database-name .] table-name [WHERE expr]

Description:

The DELETE command removes records (i.e., rows) from a table. The command keywords are followed by the database name (which is optional) and the name of the table from which records are to be removed (which is mandatory).

CAUTION:

Without a WHERE clause, all rows of the table are removed. If you supply a WHERE clause, only those rows that match the expression in that clause are removed.