csv row/records eliminated
Date: July 02, 2008 05:29PM
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.
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.