[RESOLVED] Loading a CSV Comma Delimited File into MySQL Table

KingWylim

Hello all currently I converted an excel document into csv. Now I am useing the MySQL command that looks like the following to load my file:

mysql> LOAD DATA LOCAL INFILE '/path/log.csv' INTO TABLE log
-> LINES TERMINATED BY ',';

But it inserts all of the information into the first row of the table. Any help on how I could accomplish getting this file into this table without having to enter it all manually would be greatly appreciated. This document has over 1500 entries on it so I would rather not have to enter it all by hand. I also need to have this accomplished by the end of the day.

KingWylim

I am attempting to use mysqlimport command now but I have not had any success with this as of yet. I will continue to try and see if I can't figure this out.

KingWylim

I was able to resolve the problem by useing the following code. There are still a few errors because ',' were used in the excel spreadsheet and were exported with it so some things are in the wrong areas but it's a little bit better then having to re enter all of the information I supose.

Anyways here's the code:
LOAD DATA LOCAL INFILE 'file_name.txt' INTO TABLE tbl_name FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r';

I still wish there would of been a way to be able to import all of the information with out having to worry about any damaged records. Any suggestions anyone has I would appreciate.

Roger_Ramjet

It should be somethimg like this

LOAD DATA LOCAL INFILE '/path/log.csv' INTO TABLE log
->FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n';

Roger_Ramjet

And you posted while I was posting. Re-export from Excel and Save As a Tab delimited file.

LOAD DATA LOCAL INFILE '/path/log.txt' INTO TABLE log
->FIELDS TERMINATED BY '\t' ENCLOSED BY '' LINES TERMINATED BY '\r\n';

embedded spaces, commas, etc will not cause field breaks anymore

KingWylim

Thank you very much for your help on solving this situation.