LOAD DATA INFILE 'd://test//haha.csv' REPLACE INTO TABLE `myTable` /
FIELDS TERMINATED BY ',' /
OPTIONALLY ENCLOSED BY '"' /
ESCAPED BY '//' /
LINES TERMINATED BY '/r/n'
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'
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
