使用Navicat查询MySQL数据库中哪些表建了触发器
2021-01-04 本文已影响0人
tangzhentian
SELECT DISTINCT EVENT_OBJECT_TABLE FROM information_schema.`TRIGGERS` WHERE EVENT_OBJECT_SCHEMA='数据库名'
SELECT DISTINCT EVENT_OBJECT_TABLE FROM information_schema.`TRIGGERS` WHERE EVENT_OBJECT_SCHEMA='数据库名'