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‘,‘[email protected]‘, ‘2250980621‘);
新建文档
[linux@bogon msqlite]$ vim data.txt
添加内容，格式与insert into 的相同
例如
2|lang|5445999|Hbnghian|[email protected]|121250980621
3|forng|87599|yhgaqian|[email protected]|2250980621
4|dewng|1987985|jkhjgf|[email protected]|2250980621
5|lang|5445999|Hbnghian|[email protected]|121250980621
6|forng|87599|yhgaqian|[email protected]|2250980621
7|dewng|1987985|jkhjgf|[email protected]|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;
好了！完成！
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
