mysql 根据csv文件导入数据

1.mysql -u root -p 输入密码

2.选择数据库

use database

 

2.导入文件csv文件

load data local infile 'E:\\tmp\\prod.csv' into table ${tableName} fields terminated by ',' lines terminated by '\r\n';

 

注意替换文件路径

这里还可以导入txt文件

 load data local infile 'C:\\Users\\70201\\Desktop\\asd.txt' into table ${tableName} fields terminated by '$' lines terminated by '\r\n';