mysql导入csv文件

  |   0 评论   |   6 浏览

参考资料:
https://blog.csdn.net/kikajack/article/details/80529640
https://dev.mysql.com/doc/refman/5.7/en/load-data.html

LOAD DATA INFILE 'data.txt' INTO TABLE db2.my_table;
LOAD DATA INFILE 'data.txt' INTO TABLE db2.my_table FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

标题:mysql导入csv文件
作者:SmiteLi
地址:https://smite.site/articles/2019/10/07/1570448123854.html

评论

发表评论