A quick solution to the error #1929 Incorrect datetime value: '''' for column ''createtime'' when using MySQL 5.x or above

After I installed MySQL, when I tried to save and delete table data, I always got an error message #1929 Incorrect datetime value: '' for column 'createtime', which prevented me from deleting the table data.

Cause Analysis:

For versions above 5, if the period time is a null value, NULL should be written;

The official explanation is: It is known that the new version of MySQL has a "bug" in inserting null values.

To remove the default check of enable strict SQL mode when installing MySQL

So what if we have installed mysql? The solution is to change the configuration my.ini in mysql

Solution:

Modify the my.ini configuration file. It is recommended to make a new backup before modifying it.

Find sql-mode in my.ini,

My MySQL version is 5.7.9, the default is:

sql-mode="STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE ,NO_ZERO_IN_DATE, NO_AUTO_CREATE_USER"

Delete the red marked NO_ZERO_DATE, NO_ZERO_IN_DATE , save and restart MySQL;

If the version is low, the default may be:

The default is sql-mode=" STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION ",

Delete the red marked STRICT_TRANS_TABLES , save and restart MySQL;

The above is a quick solution to the error #1929 Incorrect datetime value: '''' for column ''createtime'' that occurs when using Mysql5.x or above. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!