Re: Bulk Loading Column Mapping

[Fernando Gonzalez Sanchez]

Hi,

MySqlBulkLoader internally uses "load data" statement, but doesn't allow a lot of customization of it. I think in that case, you may want to skip over MySqlBulkLoader class and use load data directly, ie.

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

For more details http://dev.mysql.com/doc/refman/5.7/en/load-data.html