MySQL Forums
Forum List  »  Sybase

Data truncated while loading
Posted by: Harirpiya Vedula
Date: November 10, 2009 01:44AM

hi,

I have exported tables data from sybse to CSV file. and run the laod command LOAD DATA LOCAL INFILE './path.INTO TABLE table name FIELDS TERMINATED BY '|' ENCLOSED BY '' LINES TERMINATED BY '\r\n'(columns);

for some of the tables it worked fine.but for some tables where column data is more, it came to three lines. so it has taken second line as another record.

for example:

3 | 194 | 1 | Need Quote | per Rich's specifications in phone msg of 9/20/2001. Lump at 23, in between payments and retirment payments, 3 options using $240,000 per child | 2001-09-25 00:00:00.0 | N/A | Yes | null | null | 1 | Normal | null

i want this to be inserted in one single row.

thanks in advance....

Options: ReplyQuote


Subject
Views
Written By
Posted
Data truncated while loading
8912
November 10, 2009 01:44AM
5370
December 21, 2009 09:27AM
5526
January 04, 2010 07:43AM


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.