1.导出
sqlite3 tasks.db
sqlite>.output data.sql
sqlite>.dump
或
sqlite3 -csv scap.db "select * from oid_en_cn order by oid limit 0,5000 " > oid_en_cn_0_5000.csv
2.导入
sqlite> .separator ","
sqlite> .import data.txt data_table
sqlite> select * from data_txt_table;
python 脚本:
1,导出表:
cmd = "sqlite3 tasks.db '.dump table_name' > table_name.sql"
os.system(cmd)
2,导入表:
cmd = "sqlite3 tasks.db'.read table_name.sql' "
os.system(cmd)