Load Data Infile won't run under 8.0.17
Posted by: Jim Van Overschelde
Date: August 25, 2019 01:17PM

I recently upgraded from 5.7 to 8.0.17.
Now, the following command won't run:

LOAD DATA LOCAL INFILE 'e:\\Data\\SBEC\\TEA IDs\\Master_IDs 09152016.csv' Ignore into table epp.sbec_id_Loader FIELDS TERMINATED BY ',' ENCLOSED by '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES;

I get error code 1148: the used command is not allowed with this MySQL version. It seems to be the LOCAL part of the command.

Ref Manual (https://dev.mysql.com/doc/refman/8.0/en/load-data.html) shows this is valid syntax. See below

What gives? Documentation error? Bug?


LOAD DATA
[LOW_PRIORITY | CONCURRENT] [LOCAL]
INFILE 'file_name'
[REPLACE | IGNORE]
INTO TABLE tbl_name
[PARTITION (partition_name [, partition_name] ...)]
[CHARACTER SET charset_name]
[{FIELDS | COLUMNS}
[TERMINATED BY 'string']
[[OPTIONALLY] ENCLOSED BY 'char']
[ESCAPED BY 'char']
]
[LINES
[STARTING BY 'string']
[TERMINATED BY 'string']
]
[IGNORE number {LINES | ROWS}]
[(col_name_or_user_var
[, col_name_or_user_var] ...)]
[SET col_name={expr | DEFAULT},
[, col_name={expr | DEFAULT}] ...]

Options: ReplyQuote


Subject
Written By
Posted
Load Data Infile won't run under 8.0.17
August 25, 2019 01:17PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.