SQLite build table to import MySQL

New 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 (+) not NULL, mobile varchar (2), address varchar (+), email varchar (+), QQ varchar (20));

Sqlite> INSERT into the contact values (1, ' Fang ', ' 1999999 ', ' Huaqian ', ' [email protected] ', ' 2250980621 ');
New Document
[Email protected] msqlite]$ Vim Data.txt
Add content in the same format as insert INTO
For example
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
. 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;
All right! Complete!

SQLite build table to import MySQL