An example of advanced import into MySQL database using LOAD DATA INFILE #mysql #csv

import_mysql_csv.sql

/** 
 * 
 * An example of advanced import into MySQL database using LOAD DATA INFILE
 * 
 * import of first and second column from the file directly
 * third column is equal to current datetime
 * fourth column is transformed value of third column of csv file
 * ref. : http://dev.mysql.com/doc/refman/5.1/en/load-data.html 
 */

LOAD DATA INFILE 'file.txt'
  INTO TABLE t1
  (column1, column2, @var1)
  SET column3 = CURRENT_TIMESTAMP, column4 = @var1/100;