-
SQlite Tutorial
- SQLite Tutorial
- SQLite Introduction
- SQLite installation
- SQLite command
- SQLite grammar
- SQLite type of data
- SQLite Create a database
- SQLite Attach the database
- SQLite Separate the database
- SQLite Create the table
- SQLite Delete the table
- SQLite INSERT
- SQLite SELEECT
- SQLite Operator
- SQLite expression
- SQLite WHERE Clause
- SQLite AND/OR Operator
- SQLite UPDATE
- SQLite DELETE
- SQLite LIKE
- SQLite GLOB
- SQLite LIMIT
- SQLite ORDER BY
- SQLite GROUP BY
- SQLite HAVINGClause
- SQLite DISTINCTKeyword
SQLite Advanced Tutorial
- SQLite PRAGMA
- SQLite constraint
- SQLite JOINS
- SQLite UNIONS Clause
- SQLite NULL value
- SQLite Alias
- SQLite trigger
- SQLite index
- SQLite INDEX BY
- SQLite ALTERcommand
- SQLite Truncate Table
- SQLite view
- SQLite Transaction
- SQLite Subquery
- SQLite Autoincrement
- SQLite injection
- SQLite Explain
- SQLite Vacuum
- SQLite Date \u0026 Time
- SQLite Commonly used functions
SQLite interface
The best SQLite Delete statement Tutorial In 2024, In this tutorial you can learn grammar,Examples,
SQLite Delete statement
SQLiteDELETE query to delete the existing records for the table.You can use the DELETE query with a WHERE clause to delete the selected row, otherwise, all records will be deleted.
grammar
The basic syntax DELETE query with a WHERE clause as follows:
DELETE FROM table_name WHERE [condition];
You can use the AND or OR operator to combine the N number of conditions.
Examples
Suppose 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, it will delete the ID for the customer 7:
sqlite> DELETE FROM COMPANY WHERE ID = 7;
Now, 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 a WHERE clause, DELETE queries as follows:
sqlite> DELETE FROM COMPANY;
Now, COMPANY table without any record, because all records have been deleted by the DELETE statement.
Hot Tools
-
Image To Base64 Converter
Convert an image to base64 string -
Css Tools
CSS Minifier,Beautifier,Formatter -
Html Tools
Html Minifier,Beautifier,Formatter -
Base64 Decode/Encode
Base64 Decode/Encode -
Base64 To Image
Base64 To Image -
HTML Color Picker
HTML Color Picker
Other Tools
-
Web Tools
Css Minify Css Beautifier Html Minify Html Beautifier Json Minify Sql Minify XML Minify -
Image Tools
Image To Base64 Base64 To Image -
Color Tools
RGB To Hex HTML Color Picker RGB To CMYK HEX To CMYK -
Online Calculator
Calculator Scientific Calculator
Online Tutorial
- HTML online Tutorial
- javascript online Tutorial
- CSS online Tutorial
- Bootstrap online Tutorial
- React online Tutorial In 2020
- Get started with Xpath syntax
- An example of the Python Reptile Foundation Getting Started
- Introduction to XML - What is XML?
- Introduction to the JSON tutorial