当前位置:Gxlcms > 数据库问题 > SQLite - TRUNCATE TABLE

SQLite - TRUNCATE TABLE

时间:2021-07-01 10:21:17 帮助过:21人阅读

https://www.tutorialspoint.com/sqlite/sqlite_truncate_table.htm

Unfortunately, no TRUNCATE TABLE in SQLite but DELETE to delete complete data from an existing table,
though it is recommended to use DROP TABLE to drop complete table and re-create it once again.

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

DELETE FROM table_name;
VACUUM;
DROP TABLE table_name;

SQLite - TRUNCATE TABLE

标签:data   from   trunc   htm   rom   sqlite   creat   lsp   truncate   

人气教程排行