1. 创建触发器
INSERT、DELETE、UPDATE
(1)创建有一条执行语句的触发器
create trigger trigger_name
bdefore | after trigger_event //before:在触发器事件之前执行触发器语句 trigger_event:触发器事件,触发器执行条件,含DELETE、INSERT、UPDATE语句
on table_name for each row //for each row:任何一条纪录上的操作满足触发事件都会触发该触发器
trigger_stmt //trigger_stnt:激活触发器后执行的语句
例:create trigger tri_diarytime before insert on t_dept for each row insert into t_diary values(参数...);
每次往t_dept表插入数据前触发触发器,并向t_diary表插入一条数据
(2)创建包含多条执行语句的触发器
delimiter $$
create trigger trigger_name
before | after trigger_event
on table_name for each row
begin
trigger_stmt //放多条执行语句
end $$
delimiter ;
// delimiter可将语句结束符用某个其他的符号代替,此处用$$代替了; 这样放多条语句时就不会造成语句错误。最后将它变回来
2. 查看
(1)SHOW triggers \G
(2)通过系统表triggers
use information_schema;
select * from triggers \G
select * from triggers where trigger_name='要查看的触发器名' \G
3. 删除
DROP trigger trigger_name;