比如,我要查看kiddo库中有哪些表带有触发器,可以用下面的SQL:
SELECT DISTINCT EVENT_OBJECT_TABLE FROM information_schema.`TRIGGERS` WHERE EVENT_OBJECT_SCHEMA='kiddo'