(MySQL)在文件中的特定列中加载数据 [英] (MySQL) Load data infile specific columns

问题描述

我在将数据加载到表的特定列时遇到问题. CSV文件是动态生成的，其默认字段ID为LAST_REFRESH，ALIAS1和 可能包含 ALIAS2到ALIAS8.当前的CSV仅包含ALIAS1-4

I have a problem loading data into specific columns of an table. The CSV file is build dynamic with the default fields ID, LAST_REFRESH, ALIAS1 and may contain ALIAS2 to ALIAS8. Current CSV only contains ALIAS1-4

MySQL表包含ID列LAST_REFRESH ALIAS1-ALIAS8. 我的第一个文件代码已经失败.设置变量后的代码是:

The MySQL table contains the columns ID, LAST_REFRESH, ALIAS1-ALIAS8. My code for the first file already fails. Code after variables are set is:

LOAD DATA LOCAL INFILE 'C:\\temp\\\OSS001'
INTO TABLE REJECTS (ID, REFRESH_DATE, ALIAS1, ALIAS2, ALIAS3, ALIAS4)
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES

但不幸的是，我仍然收到以下错误:

But unfortunately i still receive the following error:

您的SQL语法有错误；查看与您的MySQL服务器版本相对应的手册，以在"FIELDS TERMINATED BY"附近使用正确的语法， 可选用"包围 '\ n'

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'

有人知道我在做什么错吗?

Anybody knows what i'm doing wrong?

推荐答案

列名必须最后指定.在此处了解更多信息.

The column names have to be specified last. Read more about it here.

LOAD DATA LOCAL INFILE 'C:\\temp\\\OSS001'
INTO TABLE REJECTS 
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(ID, REFRESH_DATE, ALIAS1, ALIAS2, ALIAS3, ALIAS4, ALIAS5, ALIAS6, ALIAS7, ALIAS8)

这篇关于(MySQL)在文件中的特定列中加载数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！