Mysql:触发器

目录

创建触发器

删除触发器

查看触发器

---

创建触发器

create trigger 触发器名触发时刻触发事件on表名for each row 动作;

create trigger tr_log_stu_in after insert on stu for each row
insert into log values (.....);

create trigger tr_log_stu_up after update on stu for each row
insert into log values (.....);

create trigger tr_log_stu_de befor delete on stu for each row
insert into log values (.....);

删除触发器

drop trigger 触发器名;

查看触发器

show triggers;