电脑技术学习

mysql直接读取csv文件数据到表中

dn001
LOAD DATA INFILE 'd:testhaha.csv' REPLACE INTO TABLE `myTable`
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY ''
LINES TERMINATED BY 'rn'