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

delete from tablename; select * from sqlite_sequence; update sqlite_sequence set seq=0 where name='tablename';

delete from tablename; 

select * from sqlite_sequence; 

update sqlite_sequence set seq=0 where name='tablename';


相关推荐

[!--temp.pl--]