数据样本

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

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

mysql -urootMariaDB [(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 '|--';