Alternatively, change it to 'DEFAULT NULL'.

Q&A for Work. 通过执行MYSQL>show variables;查看explicit_defaults_for_timestamp和sql_mode变量的值.

圆通把枪PDA 智联天地Simphone N2 10-04. If the problem isn't obvious then, post that line here and we'll take a look at it. 执行结果:ERROR 1067 (42000): Invalid default value for 'end_time' 原因是:Mysql5.7的explicit_defaults_for_timestamp参数默认是OFF与sql_mode的NO_ZERO_DATE冲突. ERROR 1067 (42000): Invalid default value for ‘birth’ 原因： 原文. 一、问题描述. mysql>show variables like ‘sql_mode’; Suggested fix: Work-around: explicitly type "null" in the default value column. Omit the 'DEFAULT 0' keyword from the generated statement when no value is given in the GUI for the 'Default Value' of the column. ERROR 1067 (42000): Invalid default value for 'end_time' How can I solve this issue? Press to accept default colum type (integer) Then click 'Apply' & 'Execute'. 1.
Mysql ERROR 1067: Invalid default value for 字段 12-27 1万+ 导入数据库时报错1067 – Invalid default value for ‘字段名‘ 07-12 245 .

"ERROR 1067 (42000) at line 73: Invalid default value for 'datetime'" Line 73 creates the scalar_db_rel_replied table: "CREATE TABLE IF NOT EXISTS scalar_db_rel_replied (parent_version_id int(10) unsigned NOT NULL DEFAULT '0', child_version_id int(10) unsigned NOT NULL DEFAULT '0', paragraph_num int(5) unsigned NOT NULL DEFAULT '0', 创建表执行sql语句如下： create table train ... 1067-Invalid default value for ' end_time ', Time: 0.000000s. ERROR 1067 (42000): Invalid default value for 'CREATE_TIME' ERROR 1146 (42S02): Table 'ixinnuo_zxpt.cms_user' doesn't exist 因为MySQL 5.6以后timestamp设定默认值规则改变，不能为”0000 00-00 00:00:00” 原因在于时间的默认值不兼容，查看sql_mode.

In this manner, you should be able to identify the field with the default value it doesn't like. Hope this helps! 回答1: MySQL treats timestamp in a special way, that is a little hard to find in the documentation when you don't know what you are looking for: In MySQL, the TIMESTAMP data … The Drupal Association thanks Acquia for being the #1 contributor to Drupal - With Acquia you can build, run, and optimize sites on the only Digital Experience Platform that's made for Drupal. explicit_defaults_for_timestamp = OFF 使用下面的命令查看sql_mode. MySQL：ERROR 1067 - Invalid default value for 'end_time' mysql版本：5.7.24.
Teams. mysql错误总结-ERROR 1067 (42000): Invalid default value for TIMESTAMP.

Stack Overflow for Teams is a private, secure spot for you and your coworkers to find and share information. 是因为sql_mode中的NO_ZEROR_DATE导制的，在strict mode中不允许’0000-00-00’作为合法日期.