MySql时间类型字段自动更新

alter table t_xm58_area change UpdateTime0 UpdateTime1 timestamp;
-- UpdateTime0字段设置插入或修改时均会自动更新,字段名变更为UpdateTime1
alter table t_xm58_area change CreateTime0 CreateTime1 timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP;
-- CreateTime0字段设置为插入时间,字段名变更为CreateTime1
原文地址:https://www.cnblogs.com/zran/p/8533107.html