Sqlite 简明教程
SQLite - DELETE Query
SQLite DELETE 语句用于从表中删除现有记录。可以使用 WHERE 子句与 DELETE 语句一起使用来删除选定的行，否则将删除所有记录。
SQLite DELETE Query is used to delete the existing records from a table. You can use WHERE clause with DELETE query to delete the selected rows, otherwise all the records would be deleted.
Syntax
以下是带 WHERE 子句的 DELETE 语句的基本语法。
Following is the basic syntax of DELETE query with WHERE clause.
DELETE FROM table_name
WHERE [condition];可以使用 AND 或 OR 运算符组合任意数量 N 的条件。
You can combine N number of conditions using AND or OR operators.
Example
考虑具有以下记录的 COMPANY 表。
Consider COMPANY table with 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以下是一个示例，它会 DELETE ID 为 7 的客户。
Following is an example, which will DELETE a customer whose ID is 7.
sqlite> DELETE FROM COMPANY WHERE ID = 7;现在，COMPANY 表将包含以下记录。
Now 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如果要从 COMPANY 表中 DELETE 所有记录，则无需在 DELETE 语句中使用 WHERE 子句，如下所示：
If you want to DELETE all the records from COMPANY table, you do not need to use WHERE clause with DELETE query, which will be as follows −
sqlite> DELETE FROM COMPANY;现在，COMPANY 表没有任何记录，因为所有记录都已由 DELETE 语句删除。
Now, COMPANY table does not have any record as all the records have been deleted by DELETE statement.