Sqlite没有实现TRUNCATE表操作,可以使用如下两条语句来清空表并重置起始索引号:
DELETE FROM TblName
DELETE FROM sqlite_sequence WHERE name = 'TblName';
Sqlite没有实现TRUNCATE表操作,可以使用如下两条语句来清空表并重置起始索引号:
DELETE FROM TblName
DELETE FROM sqlite_sequence WHERE name = 'TblName';