您的位置:首页技术文章

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

【字号: 日期:2023-10-14 15:09:53浏览:4作者:馨心
LOAD DATA INFILE 'd:testhaha.csv' REPLACE INTO TABLE `myTable` FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY ''' ESCAPED BY '' LINES TERMINATED BY 'rn'
标签: MySQL 数据库