Hi All,
We have an application where we load data on a daily basis and then do some
analysis and the move this data into different tables.
Data is comming in files. The date format in the file is "dd-mon-
hh24:mi:ss', but as you all know, in mysql , the default date format is
"-mm-dd hh
This is using MySQL version 3.23.49
I think I'm bringing this up again but with different errors.
This: $sql = "LOAD DATA INFILE '$file' REPLACE INTO TABLE
`jobs` FIELDS
TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '' LINES
TERMINATED BY '\\r\\n'";
is getting
> I've seen a strange replication problem with MySQL v4.0.12.
>
> mysql> LOAD DATA LOCAL INFILE '/home/andrew/upload' into table andrew FIELDS
> TERMINATED BY ',' lines terminated by '\n';
Hi,
This bug is fixed in MySQL 4.0.13 (not released yet).
Until then a patch for this is :
= sql/log_e
