Re: Error 1292: Incorrect date value: '0000-00-00' stops synchronizing

[Bruno Lousa]

Hello,

I am having a similar problem..
can anyone help me?

below is the description of the error..

mysql> LOAD DATA INFILE 'cie.csv'
-> INTO TABLE cie_bib
-> FIELDS TERMINATED BY ','
-> ENCLOSED BY '"'
-> ;
ERROR 1292 (22007): Incorrect date value: '1994/12/13"
"Eraut, M.' for column 'dataentrada' at row 1


thanks for the help
Bruno