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文件数据到表中
最新推荐文章于 2022-12-17 20:56:10 发布
LOAD DATA INFILE 'd://test//haha.csv' REPLACE INTO TABLE `myTable` /
FIELDS TERMINATED BY ',' /
OPTIONALLY ENCLOSED BY '"' /
ESCAPED BY '//' /
LINES TERMINATED BY '/r/n'