我想您缺少ENCLOSED BY子句
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文件的完整路径
加载数据文件-MySQL文档
我想您缺少ENCLOSED BY子句
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文件的完整路径
加载数据文件-MySQL文档
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
