Mysql——触发器和视图
一、Mysql触发器
触发器的定义方式
触发器的定义示例
*********************多个语句的触发器定义*************************************
create trigger trig_result_his after insert on result
for each row
begin
insert into result_history(result_id,result_des) values(new.result_id,if(new.score>=60,'通过','不及格'));
insert into result_history(result_id,result_des) values(new.result_id,date(now()));
end$$
*********************多个触发器示例*************************************
delimiter $$
create trigger trig_stu_his after insert on student
for each row
insert into student_history(stu_id,action) values(new.stu_id,'insert');
create trigger trig_stu_his1 after delete on student
for each row
insert into student_history(stu_id,action) values(old.stu_id,'delete');
create trigger trig_stu_his2 after update on student
for each row
insert into student_history(stu_id,action) values(old.stu_id,'update');
end $$
触发器的其他操作
二、Mysql视图