MySQL :: Re: In STRICT&NO_ ZERO_ DATE mode,When processing the missing date field through load data, you can insert 0000-00-00:00?

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

Re: In STRICT&NO_ ZERO_ DATE mode,When processing the missing date field through load data, you can insert 0000-00-00:00?

Posted by: Peter Brawley
Date: June 29, 2021 07:56AM

In 8.0, attempting to insert without a datatime value and without a default value into that table with your sql_mode elicits ...

ERROR 1364 (HY000): Field 'birthday' doesn't have a default value

... so I can't reproduce the result you describe.

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Written By

Posted

In STRICT&NO_ ZERO_ DATE mode,When processing the missing date field through load data, you can insert 0000-00-00:00?

Gang Fan

June 27, 2021 08:59AM

Re: In STRICT&NO_ ZERO_ DATE mode,When processing the missing date field through load data, you can insert 0000-00-00:00?

Peter Brawley

June 27, 2021 10:42AM

Re: In STRICT&NO_ ZERO_ DATE mode,When processing the missing date field through load data, you can insert 0000-00-00:00?

Gang Fan

June 27, 2021 09:00PM

Re: In STRICT&NO_ ZERO_ DATE mode,When processing the missing date field through load data, you can insert 0000-00-00:00?

Peter Brawley

June 29, 2021 07:56AM

Re: In STRICT&NO_ ZERO_ DATE mode,When processing the missing date field through load data, you can insert 0000-00-00:00?

Gang Fan

June 30, 2021 11:44PM

Re: In STRICT&NO_ ZERO_ DATE mode,When processing the missing date field through load data, you can insert 0000-00-00:00?

Peter Brawley

July 01, 2021 02:13PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.