MySQL中如何查看有触发器的表?

比如,我要查看kiddo库中有哪些表带有触发器,可以用下面的SQL:

SELECT DISTINCT EVENT_OBJECT_TABLE FROM information_schema.`TRIGGERS` WHERE EVENT_OBJECT_SCHEMA='kiddo'
posted @ 2020-04-13 15:41  荣神益人  阅读(2658)  评论(0编辑  收藏  举报