SQLite 重置主键字段

Question

我在 SQLite 中有几个表，我正在尝试弄清楚如何重置自动递增的数据库字段。

我读到 DELETE FROM tablename 应该删除所有内容并将自动增量字段重置回 0，但是当我这样做时它只会删除数据。插入新记录时，自动增量将从删除前停止的地方开始。

我的ident字段属性如下:

• 字段类型:整数
• 字段标志:PRIMARY KEY、AUTOINCREMENT、UNIQUE

我在 SQLite Maestro 中构建表并且也在 SQLite Maestro 中执行 DELETE 语句是否重要？

任何帮助都会很棒。

Answer 1

试试这个:

delete from your_table;    
delete from sqlite_sequence where name='your_table';

SQLite Autoincrement

SQLite keeps track of the largest ROWID that a table has ever held using the special SQLITE_SEQUENCE table. The SQLITE_SEQUENCE table is created and initialized automatically whenever a normal table that contains an AUTOINCREMENT column is created. The content of the SQLITE_SEQUENCE table can be modified using ordinary UPDATE, INSERT, and DELETE statements. But making modifications to this table will likely perturb the AUTOINCREMENT key generation algorithm. Make sure you know what you are doing before you undertake such changes.