mysql添加创建时间列和更新时间列

CREATE TABLE `user` (
'id' int NOT NULL AUTO_INCREMENT,
'create_time' timestamp DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
'update_time' timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP  COMMENT '更新时间',
PRIMARY KEY ('id')
);