MySQL 设置日期类型默认值

create table test(
  `id` bigint(20) not null AUTO_INCREMENT comment '主键',
  `create_time` datetime default CURRENT_TIMESTAMP comment '创建时间',
  `update_time` datetime default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP comment '修改时间',
  primary key(`id`) using btree
)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='管理表';