LOAD DATA INFILE help

[zensunni]

I've got a comma delimited txt file that goes like this:

1,3,6,3,,5,3,1
2,3,4,3,3,5,3,1

Sometimes there are empty values that just show a double comma: ",,".

So, when I use this command....

load data infile 'C:/test.txt'
into table MyTable
fields terminated by ','
lines terminated by '\n'
(a, b, c, d, e, f, g, h);

... I get an error, since the datatypes are INT. MySQL interprets the "nothing" in-between the commas to be a string.

Can anybody help me?

[r035198x]

I've got a comma delimited txt file that goes like this:

1,3,6,3,,5,3,1
2,3,4,3,3,5,3,1

Sometimes there are empty values that just show a double comma: ",,".

So, when I use this command....

load data infile 'C:/test.txt'
into table MyTable
fields terminated by ','
lines terminated by '\n'
(a, b, c, d, e, f, g, h);

... I get an error, since the datatypes are INT. MySQL interprets the "nothing" in-between the commas to be a string.

Can anybody help me?

What was the exact error message you got?

reference[/url]] An empty field value is interpreted differently than if the field value is missing:

• For string types, the column is set to the empty string.
• For numeric types, the column is set to 0.