SQL Delete Statement

Delete records from a table.

Syntax

DELETE FROM table_name [WHERE expression]
table_name:  name of the table to delete the records from
expression:   column | constant | parameter | not expression | (expression) |
expression operator expression | in (expression [, expression...])
operator:   or | and | = | != | < | > | <= | >=

Example


delete from persons where name="bob";