LOAD DATA LOCAL INFILE vs. empty fields

[xgab]

Hi! I have problems while importing tabs delimited files into tables.

I am using:

load data local infile 'C:/xxxxx/tab-delimited-file.txt' into table MyDB.MyTable fields enclosed by '\t' lines terminated by '\n' (field1, field2,field3,field4)

When MySQL a encounters empty fields within my plain tabs delimited files, it stops loading.

Which is the correct sintax ???

I already tried several combinations with other options without success...

Note: I cannot use \N to load NULL values, because I use the same text file to load an Informix Table that does not accept it.

Thank you in advance!

[steadyguy]

Have you tried using the empty string ('')?

[xgab]

Thank you. I will try that.