您的位置主页 > MYSQL

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'