windows环境下将csv文件导入mysql

1.进入相应的数据库

2.运行命令

  load data local infile 'F:/data.csv' into table big_data  character set gbk fields terminated by ','  optionally enclosed by '"' escaped by '"'   lines terminated by '\r\n';

 

转载于:https://www.cnblogs.com/luohero/p/7832647.html