MySQL Forums
Forum List  »  CSV Storage Engine

csv row/records eliminated
Posted by: heather campagna
Date: July 02, 2008 05:29PM

Hello

Can I get some help please to a seemingly simple problem. I have a excel/csv file. The data is in ROWS and Column format. I want to insert into mysql using the below sql code. It works but.....

The PROBLEM IS: it is broken up into rows/records in mysql, I need it to ignore the returns or breaks or whatever tells it to go to another row and continue to insert the data into the fields in one record. Did I explain that right?

LOAD DATA INFILE 'filename.csv'
INTO TABLE tablename
FIELDS TERMINATED BY ','
(`1`, `2`, `3`, `4`, `5`, `6`)

I dont know what I am doing so I may not have explained it properly please ask any questions that you may be confused about.



Edited 1 time(s). Last edit at 07/02/2008 06:04PM by heather campagna.

Options: ReplyQuote


Subject
Views
Written By
Posted
csv row/records eliminated
8744
July 02, 2008 05:29PM


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.