It's a little bit cool. With mysql5.x above version error #1929 incorrect datetime value: ' For column ' createtime ' workaround

After my MySQL installation, save delete table data always appears #1929 incorrect datetime value: ' For column ' createtime ' ERROR alert, resulting in the inability to delete tables data;

Reason:

More than 5 versions should be written null if the time period is null;

The official explanation said: "The new version of MySQL to insert a null value" bug,

To remove the default checkmark when installing MySQL, enable strict SQL mode

So what if we install MySQL, the workaround is to change the configuration in MySQL My.ini

Workaround:

Modify the My.ini configuration file, it is recommended to modify the pre-new backup,

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"

No_zero_date,no_zero_in_date the Red label , delete the save 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",

Strict_trans_tables the Red label , delete the save restart MySQL;

It's a little bit cool. With mysql5.x above version error #1929 incorrect datetime value: ' For column ' createtime ' workaround