>>>> 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql