Bug #17090 error with LOAD DATA INFILE statement
Submitted: 3 Feb 2006 5:00 Modified: 3 Feb 2006 8:51
Reporter: Nithya vijayaraghavan Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0 OS:Windows (windows 2000 professional sp4)
Assigned to: CPU Architecture:Any

[3 Feb 2006 5:00] Nithya vijayaraghavan 
Description:
I've been using mysql server 5.0.16 win 32 for quite sometime..when i try to load data using LOAD DATA INFILE command or lOAD DATA LOCAL INFILE it throws error as this row1 doesn't contain data for all columns... rowid is one of columns in my txt file to be loaded..
the syntax which i used is 
 
LOAD DATA INFILE "bionet1.txt" into table bionet1   FIELDS TERMINATED BY ',';
i created the table before hand using command line client..
and i tried loading a csv file also instead of text for the same table that time i got this error "OUT OF RANGE VALUE ADJUSTED FOR COLUMN 'rowid' at row1. i want a solution for this problem, since the tables which i use are very big containing thousands of rows and doing insert statements for them makes the job very tedious.

How to repeat:
I've been using mysql server 5.0.16 win 32 for quite sometime..when i try to load data using LOAD DATA INFILE command or lOAD DATA LOCAL INFILE it throws error as this row1 doesn't contain data for all columns... rowid is one of columns in my txt file to be loaded..
the syntax which i used is 
 
LOAD DATA INFILE "bionet1.txt" into table bionet1   FIELDS TERMINATED BY ',';
i created the table before hand using command line client..
and i tried loading a csv file also instead of text for the same table that time i got this error "OUT OF RANGE VALUE ADJUSTED FOR COLUMN 'rowid' at row1. i want a solution for this problem, since the tables which i use are very big containing thousands of rows and doing insert statements for them makes the job very tedious.
[3 Feb 2006 8:51] Hartmut Holzgraefe 
We're sorry, but the bug system is not the appropriate forum for 
asking help on using MySQL products. Your problem is not the result 
of a bug.

Support on using our products is available both free in our forums
at http://forums.mysql.com and for a reasonable fee direct from our
skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

Additional info:

Hint: you want to check your sql_mode setting for STRICT_TRANS_TABLE or TRADITIONAL,
see http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html