sqlite - 在 SQLite 中设置 AUTOINCREMENT 的起始值

Question

如何在 SQLite 中设置 AUTOINCREMENT 字段的起始值？

Answer 1

来自SQLite web site :

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.

我试过了，效果不错:

UPDATE SQLITE_SEQUENCE SET seq = <n> WHERE name = '<table>'

n+1 是您想要的下一个 ROWID，table 是表名。