From Mysql docs:
You can also discard an input value by
assigning it to a user variable and
not assigning the variable to a table
column:
LOAD DATA INFILE 'file.txt'
INTO TABLE t1 (column1, @dummy, column2, @dummy, column3);
From Mysql docs:
You can also discard an input value by
assigning it to a user variable and
not assigning the variable to a table
column:
LOAD DATA INFILE 'file.txt'
INTO TABLE t1 (column1, @dummy, column2, @dummy, column3);