In SQLite, DELETE query is used to delete the existing records from a table. You can use it with WHERE clause or without WHERE clause. WHERE clause is used to delete the specific records (selected rows), otherwise all the records would be deleted.
Syntax:
Note: We can use N number of "AND" or "OR" operators with "WHERE" clause.
Example:
We have an existing table named "STUDENT", having the following data:
![Sqlite Delete query 1](https://static.javatpoint.com/sqlite/images/sqlite-delete-query1.png)
Example1:
Delete the records of a student from "STUDENT" table where ID is 4.
![Sqlite Delete query 2](https://static.javatpoint.com/sqlite/images/sqlite-delete-query2.png)
The student's record of id 4 is deleted; you can check it by using SELECT statement:
Output:
![Sqlite Delete query 3](https://static.javatpoint.com/sqlite/images/sqlite-delete-query3.png)
Example2:
If you want to delete all records from the table, don't use WHERE clause.
![Sqlite Delete query 4](https://static.javatpoint.com/sqlite/images/sqlite-delete-query4.png)
You can see that there is no data in the table "STUDENT".
No comments:
Post a Comment