且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

SQLite空表和自动增量字段

更新时间:2023-02-12 08:28:53

您可以删除并重新创建表,或者
You can drop and recreate the table, or
delete from sqlite_sequence where name=''%TABLE NAME%''; 


更多信息:
http://sqlite.org/autoinc.html [


More info:
http://sqlite.org/autoinc.html[^]

Good luck!


使用此功能(其中tablename是您的表):

Use this (where tablename is your table):

DELETE FROM tablename;    
DELETE FROM sqlite_sequence WHERE name = 'tablename';