mysql直接读取csv文件数据到表中
LOAD DATA INFILE 'd:\\test\\haha.csv' REPLACE INTO TABLE `myTable` FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'
LOAD DATA INFILE 'd:\\test\\haha.csv' REPLACE INTO TABLE `myTable` FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'