1,Linux导入数据:
.separator ","
.import /home/tangtao/mynode/linuxnetPrograme/Socket-master/chatroom_select/chatRome.db mydb
select * from mydb;
2,linux导出数据:
sqlite3 db.sqlite3
sqlite> .output /home/dump666.sql
.dump table_name
如果是导出全部表:
直接 .dump