LOAD DATA LOCAL INFILE '/tmp/foo.txt' INTO TABLE foo FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' (@col1,@col2,@col3) set myid=@col1,mydecimal=@col3;

engine.execute("LOAD DATA LOCAL INFILE '%s' INTO TABLE %s FIELDS TERMINATED BY '%s' LINES TERMINATED BY '%s' (%s) set %s",[file,table,fields_terminated,lines_terminated,columns,insert_columns])