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
3593
July 29, 2018 11:09PM
1111
July 30, 2018 10:41AM


Sorry, you can't reply to this topic. It has been closed.

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.