Sqlite 清空表中所有数据 并重置自增长数据

来源:互联网 发布:python 盲水印 编辑:程序博客网 时间:2024/05/16 11:09
delete from table_name; 
select * from sqlite_sequence; 
update sqlite_sequence set seq=0 where name='table_name';
0 0