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

Reply via email to