thanks, that's what I feared already..
although ugly, will do it that way so far as I don't want to do any other
pre-processing on the fixed CSV's I receive.
moreover I just found out STR_TO_DATE isn't available in mysql 4.0 anyway..
Michael
> -Original Message-
> From: Jigal van Hemert
> using mysql 4.0.24 I'm stuck with a problem importing a CSV-file
converting the date in the CSV from MM/DD/ to a mysql table..
>
> I'm trying:
> LOAD DATA INFILE '/tmp/mydata.csv'
> INTO TABLE mytable
> FIELDSTERMINATED BY ','OPTIONALLY ENCLOSED BY '"'
> (recordType, serviceTy
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/ to a mysql table..
I'm trying:
LOAD DATA INFILE '/tmp/mydata.csv'
INTO TABLE mytable
FIELDSTERMINATED BY ','OPTIONALLY ENCLOSED BY '"'
(recordType, serviceType,STR_
