sqlite建立表格匯入mysql

標籤：io   ar   for   on   cti   ad   linux   as   sql   

建立sqlite

[[email protected] 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‘);
建立文檔
[[email protected] 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;
好了！完成！

sqlite建立表格匯入mysql