Trouble uploading/importing files to MySQL server
Trouble uploading/importing files to MySQL server
(OP)
I keep getting an error message that the file I'm trying to upload cannot be found. Could someone please reply with an example using the proper syntax for importing data using the LOAD DATA command?
I tried:
LOAD DATA LOCAL INFILE 'test_db.csv' INTO TABLE admintest
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\r';
I tried:
LOAD DATA LOCAL INFILE 'test_db.csv' INTO TABLE admintest
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\r';
RE: Trouble uploading/importing files to MySQL server
RE: Trouble uploading/importing files to MySQL server
RE: Trouble uploading/importing files to MySQL server