MySQL 时间字段默认值 alter table XXX add create_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP comment '创建时间' alter table XXX add update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP comment '更新时间' -------------------------------------------------------------------------------------------------------------------------------------------------------------- 白云苍狗时光飞,嘻嘻哈哈一生追。哈!