From: hsv
Date: November 15 2012 3:47pm
Subject: Re: Issue regarding the import of the date from csv file to
  the      table in the database in mysql
List-Archive: http://lists.mysql.com/mysql/228638
Message-Id: <B0120225940@mailhome.tbbs.net>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

>>>> 2012/11/15 00:30 +0100, Mogens Melander >>>>
I guess I'm sill learning.

Does that mean that, if the last column in a load blabla. is a 0000-00-00
terminated by ^n it might error ? Or are we talking ODBC ?
<<<<<<<<
Find it under LOAD DATA ....

If an empty field is parsed for a NOT NULL DATE or DATETIME, instead of reporting error as in strict mode, the parser makes the date 0000-00-00--Maybe in ODBC, too, which I do not know, but certainly from character input. (I regularly use CSV files with MySQL, although the match is not perfect.) This is a particular case of "zero" (see LOAD DATA) for any NOT NULL type.