YouTipSqlite Delete
# SQLite DELETE Statement
SQLite's **DELETE** query is used to delete existing records from a table. You can use a DELETE query with a WHERE clause to delete selected rows; otherwise, all records will be deleted.
## Syntax
The basic syntax of a DELETE query with a WHERE clause is as follows:
DELETE FROM table_name WHERE ;
You can use AND or OR operators to combine N number of conditions.
## Example
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
Following is an example which will DELETE the customer whose ID is 7:
sqlite> DELETE FROM COMPANY WHERE ID = 7;
Now, the COMPANY table will have 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 the records from the COMPANY table, you do not need to use the WHERE clause. The DELETE query would be as follows:
sqlite> DELETE FROM COMPANY;
Now, the COMPANY table will have no records because all records have been deleted through the DELETE statement.