sqlite建立表格导入mysql

新建sqlite

[linux@bogon msqlite]$ sqlite3 contact.db
SQLite version 3.6.20
Enter ".help" for instructions
Enter SQL statements terminated with a ";"

create table contact (id integer auto_increment, name varchar(32) NOT NULL, mobile varchar(2), address varchar(128), email varchar(128), qq varchar(20));

sqlite> insert into contact values(1, 'fang','1999999', 'Huaqian','sss@qq.com', '2250980621');
新建文档
[linux@bogon msqlite]$ vim data.txt
添加内容，格式与insert into 的相同
例如
2|lang|5445999|Hbnghian|534@qq.com|121250980621
3|forng|87599|yhgaqian|123@qq.com|2250980621
4|dewng|1987985|jkhjgf|654@qq.com|2250980621
5|lang|5445999|Hbnghian|534@qq.com|121250980621
6|forng|87599|yhgaqian|123@qq.com|2250980621
7|dewng|1987985|jkhjgf|654@qq.com|2250980621

导入
.import ./data.txt contact
sqlite> .output cc.sql
sqlite> .dump contact
sqlite> select *from contact;
sqlite> .output stdout
sqlite> drop table contact;

sqlite> select *from contact
ysql> drop database contact;
mysql> source ./cc.sql;
好了！完成！

转载于:https://www.cnblogs.com/be-m/p/4135986.html