MySQL Forums
Forum List  »  Knowledge Base

Load data File
Posted by: jude alex
Date: October 25, 2008 12:19AM

Hello,
I am trying to do a bulk load from a csv file into the database. But the csv contains last line as blank. I am not able to load because it throws me an error stating last row does not value for all the colums.
This is the query i am using,
LOAD DATA low_priority INFILE '<path>.csv'
INTO TABLE stock.symbols_amex
FIELDS TERMINATED BY ','
lines TERMINATED BY '\n'
IGNORE 1 LINES
(Date,Open,High,Low,Close,Volume,`Adj Close`);

Please guide me, how should it be done.

Options: ReplyQuote


Subject
Views
Written By
Posted
Load data File
5508
October 25, 2008 12:19AM
2842
October 28, 2008 10:39AM


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.