DELETE

Remove rows from a table. You can use a WHERE clause to specify which rows should be removed.

Syntax

DELETE FROM <table_name>
[ WHERE <predicate> ]

Examples

Deletes with conditions:

DELETE FROM t WHERE a > 1;

Deletes all the data:

DELETE FROM t;