LOAD DATA INFILE "D:/csv03011039.csv"REPLACE INTO TABLE download_csvCHARACTER SET utf8FIELDS TERMINATED BY "," ENCLOSED BY ""LINES TERMINATED BY "\r\n";
d:\xxx.csv注意文件路径
注意路径的斜杠写错了。
更多MySQL 导入导出 csv excel 等问题,可以看这篇,有不少深坑都概述了,写的挺细。