SQL As Understood By SQLite
DELETE
sql-statement ::= | DELETE FROM [database-name .] table-name [WHERE expr] |
The DELETE command is used to remove records from a table. The command consists of the "DELETE FROM" keywords followed by the name of the table from which records are to be removed.
Without a WHERE clause, all rows of the table are removed. If a WHERE clause is supplied, then only those rows that match the expression are removed.