创建表catagory
CREATE TABLE `catagory` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`create_time` datetime DEFAULT NULL,
`update_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8
创建触发器create_time用于记录用户往catagory表插入数据的时间
DELIMITER $$
CREATE
TRIGGER `lan`.`create_time` BEFORE UPDATE
ON `lan`.`catagory`
FOR EACH ROW BEGIN
SET new.create_time=NOW();
END$$
DELIMITER ;
创建触发器update_time用于记录用户更新catagory表数据的时间
DELIMITER $$
CREATE
TRIGGER `lan`.`update_time` BEFORE UPDATE
ON `lan`.`catagory`
FOR EACH ROW BEGIN
SET new.update_time=NOW();
END$$
DELIMITER ;