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 ' ';