delete from TableName; //清空数据 update sqlite_sequence SET seq = 0 where name =‘TableName‘;//自增长ID为0 CREATE TABLE "User2" (uid INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(50) NOT NULL)//自增
SQLite小结
原文：http://my.oschina.net/airship/blog/392187
