数据库笔记

1. sqlite数据表ID复位:
delete from tablename;
update sqlite_sequence set seq ='0' where name ='tablename';