Deleting data

delete works for both single-row and multiple-row operations.

The where clause specifies which rows are to be removed. When no where clause is given in the delete statement, all rows in the table are removed. See the Reference Manual: Commands.