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
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,
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,