转载自:https://www.jianshu.com/p/0835b48e2637
简介
- 触发器是由MySQL 的基本命令事件来触发某种特定操作,这些基本命令由insert、update、delete等事件触发某些特定操作
查看触发器
show triggers;
创建触发器
create trigger trigger_name before | after insert | update | delete on table_name for each row
create trigger trigger_name before | after insert | update | delete on table_name for each row
begin
执行语句;
执行语句;
end
删除触发器
DROP trigger trigger_name;