Error: Incorrect integer value: '' for column 'Comp' at row 1

[kctigers23]

Hey, I can't get the load data infile command to work to load data from a CSV file.

 

The code is"

load data infile  "2004AugSep.csv" into table 2004pbp

 

FIELDS TERMINATED BY ','

LINES TERMINATED BY '\n'

IGNORE 1 LINES;

 

The error is

 

Incorrect integer value: '' for column 'Comp' at row 1

 

the data value is going into an Int(5) column, but I've tried every thing there. The CSV for this entry is blank, so it's something like

 

previous column,,next column

 

 

thanks in advance

[fenway]

Empty strings aren't valid integers... I assume you have strict mode on.