LOAD DATA INFILE 'file.txt'
  INTO TABLE t1
  (column1, @dummy, column2, @dummy, column3);

load data infile 'filelocation../file.csv' into
    table myTable columns terminated by ',' optionally enclosed by '"'
    escaped by '"' lines terminated by 'n'(@value1,@value2,@discardValue,@value4)
    set f1=@value1 ,f2=@value2,f3=@value4;