【Mysql】数据库timestamp默认值‘0000-00-00 00:00:00’创建表结构失败

错误来源：

DROP TABLE IF EXISTS sys_role;
CREATE TABLE sys_role (
id varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT ‘id’,
data_scope varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT ‘数据权限’,
permission varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT ‘功能权限’,
name varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT ‘角色名称’,
create_time timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT ‘create_time’,
create_by varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT ‘create_by’,
update_time timestamp(0) NOT NULL DEFAULT ‘0000-00-00 00:00:00’ COMMENT ‘update_time’,
update_by varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT ‘update_by’,
is_delete bit(1) NULL DEFAULT NULL COMMENT ‘delete’,
create_unit_id varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT ‘创建单位’,
remark varchar(500) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
PRIMARY KEY (id) USING BTREE,
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = ‘角色表’ ROW_FORMAT = Compact;

**上述sql中的update_time报错：**

```java
Invalid default value for ‘update_time’

mysql为docker安装
首先查看一下mysql的版本：5.7.17

错误原因为：mysql中sql_mode设置问题。修改mysql配置文件my.cnf
要直接修改文件需先安装一下vim：

apt-get update
apt-get install vim

找到mysql.cnf

修改如下：

[mysqld]
sql-mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

注意：一定一定要加上[mysqld]
重启mysql就搞定了！