SQLite并不支持TRUNCATE TABLE语句

方式一:

DELETE FROM [Tab_User] --不能将递增数归零

方式二:

DELETE FROM sqlite_sequence WHERE name = ‘TableName’; --可以将递增数归零

详细看我从其他博友园子里扒来的介绍:

05-11 00:01