LOAD DATA INFILE '/tmp/filename.csv' INTO TABLE my_table
     FIELDS TERMINATED BY ';'
     LINES TERMINATED BY 'n'
     (zipcode, @date_variable, `code`, @time_from, @time_to)
     SET `date` = STR_TO_DATE(@datevar, '%d-%m-%Y'),
         `timefrom` = CONCAT(@timefromvar, '00'),
         `timeto` = CONCAT(@timetovar, '00');

mysqlimport --host='****' --user='****' --password='****' --port='3306' --local --fields-terminated-by=';' --lines-terminated-by='n' --columns='pc, @datevar, `code`, @timefromvar, @timetovar' db_name /tmp/my_table.csv