skip columns while using LOAD command mysql
From the documentation:


  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);