LOAD DATA LOCAL INFILE
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!
Subject
Views
Written By
Posted
LOAD DATA LOCAL INFILE
3595
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.