# select now();
# set global time_zone = '+8:00'


  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`create_time` datetime NOT NULL DEFAULT now() COMMENT '创建时间',


alter table user_account modify column update_time DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间';



# centos 修改系统时间

date -R
ln -sf /usr/share/zoneinfo/Asia/Shanghai /etc/localtime
date -R