Problem with LOAD DATA of selected fields from input record

[Yigal Douchan]

Hi,

I have a table (TBL) with 2 fields only: a,b. I need to load these two fields from an input tab seperated file (in.tab), which contains 3 fields in this order: a,c,b. As I said, I need to load only a & b.

The following commands:

delete if exists from TBL;
load data infile "d:\\in.dat" into table TBL lines terminated by '\n' (a,b);

causes a & c to be loaded into TBL, instead of a & b.

How can I load a & b into TBL from this in.tab file?

Thanks, Yigal