自己做过的测试：
@H_403_2@select COUNT （*） AS linenum from Table_name
@H_403_2@
@H_403_2@select * from table_name limit N
@H_403_2@
@H_403_2@select rowid,* from table_name //最左边一列段名为rowid，从1开始
http://www.sqlite.org/lang_createtable.html#rowid
@H_403_2@
删除某段范围的记录
delete from system where rowid in (select rowid from system limit N,M)
一次插入多行数据
INSERT INTO table_name （‘culumn_name1’， 'column_name2'） VALUES (xxx,xxx),(xxx,xxx)
exp：
insert into CFG ('CfgName','CfgValue') VALUES ('days',365),('number',30000)
