Sqlite 简明教程

SQLite - TRUNCATE TABLE Command

很不幸的是，SQLite 中没有 TRUNCATE TABLE 命令，但你可以使用 SQLite 的 *DELETE * 命令来删除现有表中所有数据，尽管建议使用 DROP TABLE 命令来删除完整表并重新创建它。

Unfortunately, we do not have TRUNCATE TABLE command in SQLite but you can use SQLite *DELETE * command to delete complete data from an existing table, though it is recommended to use DROP TABLE command to drop the complete table and re-create it once again.

Syntax

下面是 DELETE 命令的基本语法。

Following is the basic syntax of DELETE command.

sqlite> DELETE FROM table_name;

下面是 DROP TABLE 的基本语法。

Following is the basic syntax of DROP TABLE.

sqlite> DROP TABLE table_name;

如果你使用 DELETE TABLE 命令来删除所有记录，建议使用 VACUUM 命令来清除未使用的空间。

If you are using DELETE TABLE command to delete all the records, it is recommended to use VACUUM command to clear unused space.

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

下面是在上表中截断的示例 −

Following is the example to truncate the above table −

SQLite> DELETE FROM COMPANY;
SQLite> VACUUM;

现在，COMPANY 表已截断完成，并且 SELECT 语句不会有任何输出。

Now, COMPANY table is truncated completely and nothing will be the output from SELECT statement.