本文介绍了找出哪些表受触发器影响的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
在MySQL中(尤其是InnoDB),有什么方法可以知道CASCADE UPDATES / DELETES或常规触发器对哪些表产生了影响(更新/删除的行)?
In MySQL (particularly InnoDB) is there any way to know which tables were affected (updated / deleted rows) by CASCADE UPDATES / DELETES or regular triggers?
推荐答案显示级联和约束:
Show the cascades and constraints:
mysql> SHOW CREATE TABLE tablename;显示触发器:
Show triggers:
mysql> USE dbname; mysql> show triggers;更多推荐
找出哪些表受触发器影响
发布评论