SQLITE TRUNCATE TABLE 技术教程文章

SQLite - TRUNCATE TABLE

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;...