mysql 设置 update操作时自动更新时间字段

建表

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;