mysql命令行导入结构化数据

weixin_30572613

于 2017-11-03 10:18:00 发布

阅读量163

点赞数

原文链接：http://www.cnblogs.com/passedbylove/p/7776905.html

版权

数据样本

103252765-|--|-stephanie_mt@hotmail.com-|-o/35+nGaNEU=-|-ion|--

其中|为分隔符,每行的换行符\n

mysql -uroot

MariaDB [(none)]> use test;
MariaDB [license]> load data local infile 'e:/export.sql' into table user fields terminated by '|' lines terminated by '\n'(id,username,email,password,hit);

mysql> use license;
Database changed
mysql> load data local infile 'e:\cred.csv' into table leak_adobe_user fields terminated by '-|-' lines terminated by '|--';

转载于:https://www.cnblogs.com/passedbylove/p/7776905.html