mysql命令行导入结构化数据
数据样本
103252765-|--|-stephanie_mt@hotmail.com-|-o/35+nGaNEU=-|-ion|--
其中|为分隔符,每行的换行符
mysql -uroot MariaDB [(none)]> use test; MariaDB [license]> load data local infile 'e:/export.sql' into table user fields terminated by '|' lines terminated by ' '(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 '|--';