skip columns while using LOAD command mysql I have a csv file having 5 columns and i want to load only one out of that, is there a way i can do it. I want to use LOAD statement of MySQL 5.5
Any pointers are welcomed, help would be much appreciated
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);