|List:||General Discussion||« Previous MessageNext Message »|
|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
|View as plain text|
>>>> 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.