建表
CREATE TABLE `time_update` ( `id` int(10) unsigned NOT NULL DEFAULT '0', `name_seq` int(10) unsigned NOT NULL DEFAULT '0', `mod_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB
INSERT INTO `time_update` VALUES(1,1,now()); UPDATE `time_update` SET name_seq=name_seq+1 WHERE id=1 LIMIT 1;
标签:seq,DEFAULT,mysql,update,自动更新,time,NULL,id From: https://www.cnblogs.com/boye169/p/16648757.html