LOAD DATA LOCAL INFILE '$fname' INTO TABLE $tname FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' (trade_date,....,@var) SET trade_date = str_to_date(@var, '%d/%m/%Y');