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