SQLite清空表

1.删空表格

delete from '表名';   

2.查看自增ID 

select * from sqlite_sequence;    

3.更新自增ID为0

update sqlite_sequence set seq=0 where name='表名';