且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何将csv文件导入MySQL工作台?

更新时间:2022-02-23 16:23:36

我想你缺少ENCLOSED BY子句

I guess you're missing the ENCLOSED BY clause

LOAD DATA LOCAL INFILE '/path/to/your/csv/file/model.csv' INTO TABLE test.dummy FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';

并指定csv文件完整路径

And specify the csv file full path

载入数据Infile - MySQL文档