SQLite Delete Statement

Syntax

The basic syntax of a DELETE query with a WHERE clause is as follows:

DELETE FROM table_name
WHERE [condition];

You can use the AND or OR operators to combine N number of conditions.

Examples

Assume the COMPANY table has the following records:

ID          NAME        AGE         ADDRESS     SALARY
----------  ----------  ----------  ----------  ----------
1           Paul        32          California  20000.0
2           Allen       25          Texas       15000.0
3           Teddy       23          Norway      20000.0
4           Mark        25          Rich-Mond   65000.0
5           David       27          Texas       85000.0
6           Kim         22          South-Hall  45000.0
7           James       24          Houston     10000.0

Here is an example that will delete the customer with ID 7:

sqlite> DELETE FROM COMPANY WHERE ID = 7;

Now, the COMPANY table has the following records:

ID          NAME        AGE         ADDRESS     SALARY
----------  ----------  ----------  ----------  ----------
1           Paul        32          California  20000.0
2           Allen       25          Texas       15000.0
3           Teddy       23          Norway      20000.0
4           Mark        25          Rich-Mond   65000.0
5           David       27          Texas       85000.0
6           Kim         22          South-Hall  45000.0

If you want to delete all records from the COMPANY table, you do not need to use the WHERE clause; the DELETE query is as follows:

sqlite> DELETE FROM COMPANY;

Now, the COMPANY table has no records, because all records have been deleted by the DELETE statement.