MySQL Forums
Forum List  »  General

Load Data Local Infile Problem
Posted by: Arvind Kanda
Date: March 13, 2011 07:29AM

Hello all,

I am using the below script to load a file into a table.

LOAD DATA LOCAL INFILE '/home/public_html/new_price_and_qty.csv'
INTO TABLE import_qty_and_price
FIELDS TERMINATED BY ',' ;

The table is empty before loading the table. There are eight columns in both the csv file and the table. For some reason, it updates five columns, but it does not update the other three. It updates the first through fourth and then the last column. The other three columns in between gets updated with zeros.

Any idea why this happens?

I appreciate your help.

Arvind.

Options: ReplyQuote


Subject
Written By
Posted
Load Data Local Infile Problem
March 13, 2011 07:29AM


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.