Loading data with INFILE
Posted: 18. February 2009 04:30
I would like to import data from a csv and at the same time alter a date field from YYYY-MM-DD to MM-DD-YYYY. If I use the following command, where do I place my source .csv file?
LOAD DATA [LOCAL] INFILE 'file_name'
INTO TABLE tbl_name
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(field1,field2,field3,varcharDate,...)
SET `date` = STR_TO_DATE( varcharDate, '%m-%d-%Y' ) ;
LOAD DATA [LOCAL] INFILE 'file_name'
INTO TABLE tbl_name
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(field1,field2,field3,varcharDate,...)
SET `date` = STR_TO_DATE( varcharDate, '%m-%d-%Y' ) ;