Hi,
using mysql 4.0.24 I'm stuck with a problem importing a CSV-file converting the
date in the CSV from MM/DD/YYYY to a mysql table..
I'm trying:
LOAD DATA INFILE '/tmp/mydata.csv'
INTO TABLE mytable
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(recordType, serviceType,STR_TO_DATE(gmtDate,'%m/%d/%Y');
The date in the CSV-file field #3 is in format MM/DD/YYYY and therefore not
importet correctly;
Obvisouly I'm missing something on how to use functions for columns with LOAD
DATA INFILE ?
TIA, Michael
3 messages in com.mysql.lists.mysqlLOAD DATA INFILE and STR_TO_DATE
