Saturday, October 19, 2019

SQLite DELETE Query

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:
  1. DELETE FROM table_name  
  2. WHERE [conditions....................];;  

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
Example1:
Delete the records of a student from "STUDENT" table where ID is 4.
  1. DELETE FROM STUDENT WHERE ID = 4;   
Sqlite Delete query 2
The student's record of id 4 is deleted; you can check it by using SELECT statement:
  1. SELECT * FROM STUDENT;  
Output:
Sqlite Delete query 3
Example2:
If you want to delete all records from the table, don't use WHERE clause.
  1. DELETE FROM STUDENT;   
Sqlite Delete query 4
You can see that there is no data in the table "STUDENT".

No comments:

Post a Comment

How to DROP SEQUENCE in Oracle?

  Oracle  DROP SEQUENCE   overview The  DROP SEQUENCE  the statement allows you to remove a sequence from the database. Here is the basic sy...