mysql触发器

最新推荐文章于 2025-04-18 16:35:30 发布

weixin_30437481

最新推荐文章于 2025-04-18 16:35:30 发布

阅读量61

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/mengluo/p/5428165.html

| student | CREATE TABLE `student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(20) DEFAULT NULL,
  `name` varchar(20) DEFAULT NULL,
  `sex` varchar(20) DEFAULT NULL,
  `age` int(2) DEFAULT NULL,
  `dept` varchar(20) DEFAULT NULL,
  `times` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 |

create trigger ceshia1 after update on t_student for each ROW
BEGIN
select stu_id,stu_code,stu_name,stu_sex,age,stu_dept,NOW()
into @v8,@v1,@v2,@v3,@v4,@v5,@v6 from t_student where stu_id=old.stu_id;
insert into student values(@v8,@v1,@v2,@v3,@v4,@v5,@v6);
end;

转载于:https://www.cnblogs.com/mengluo/p/5428165.html