(1)打开数据库:sqlite3 数据名.db
(2)查看表当前行数:select count(*) from 表名;
(3)删除表前n行:delete from 表名 where 排序字段 in (select 排序字段 from 表名 order by 排序字段 limit 0,n-1);
(4)查看表现在行数:select count(*) from 表名;
....#sqlite3 MySQL.db
sqlite> select count(*) from my_table;
165954
sqlite> delete from my_table where id in (select id from my_table order by id limit 0,999);
sqlite> select count(*) from my_table;
164955