MySQL Forums
Forum List  »  MySQL Query Browser

ERROR 1265 (01000) at line 1: Data truncated for column 'RC' at row 1 Press any key to continue . . .
Posted by: David Torque
Date: June 28, 2013 11:06PM

I am having this issue. The LOAD Data function works fine if i run it via SQL Browser. When i put it into a batch file and run it i receive this error.

ERROR 1265 (01000) at line 1: Data truncated for column 'RC' at row 1 Press any key to continue . . .


LOAD DATA LOCAL INFILE 'E:\\Data\\TS\\TEST\\TEST.csv' REPLACE
INTO TABLE `tsdata`.`testtable`

FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'

LINES TERMINATED BY '\n'

IGNORE 1 LINES
(`Tcode`,`Track`,`Going`,`Distance`,`1SECMPS`,`2SECMPS`,`3SECMPS`,`IVRAVG`,`RC`);

any ideas?

Options: ReplyQuote


Subject
Written By
Posted
ERROR 1265 (01000) at line 1: Data truncated for column 'RC' at row 1 Press any key to continue . . .
June 28, 2013 11:06PM


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.