mysql 触发器的创建
1 创建
语法 create trigger trigger_name after/before insert/update on 表名 for each row begin sql语句 end;
2 删除
drop trigger trigger_name
3 查询
show triggers;
show trigger like “%abc%”
mysql 触发器的创建
1 创建
语法 create trigger trigger_name after/before insert/update on 表名 for each row begin sql语句 end;
2 删除
drop trigger trigger_name
3 查询
show triggers;
show trigger like “%abc%”