mysql 查看表记录新增、修改的时间

ALTER TABLE `tableName` ADD `updateAt` TIMESTAMP NULL ON UPDATE CURRENT_TIMESTAMP;

ALTER TABLE   kd_uploadinfo   ADD  optime  TIMESTAMP  NOT NULL  DEFAULT CURRENT_TIMESTAMP  ON UPDATE CURRENT_TIMESTAMP;
ALTER TABLE   kd_uploadinfo   ADD  STATUS  VARCHAR(10) NOT NULL DEFAULT 'add' COMMENT '附件状态,add--新增  delete--删除';

 

转载于:https://www.cnblogs.com/a198720/p/3939064.html