MySQL Forums
Forum List  »  MySQL Workbench

LOAD DATA LOCAL INFILE
Posted by: Ron Rumack
Date: July 29, 2018 11:09PM

As part of a Lynda course, I have been trying to do an import of some data using the following script:

LOAD DATA LOCAL INFILE 'C:\\FILENAME.csv'
INTO TABLE pop_proj
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES;

I keep getting the same error message:
Code: 1148. The used command is not allowed with this MySQL version 0.000 sec

Any help would be much appreciated!

Options: ReplyQuote


Subject
Views
Written By
Posted
LOAD DATA LOCAL INFILE
198
July 29, 2018 11:09PM
99
July 30, 2018 10:41AM


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.