Mysql获取数据库的所有触发器SQL
文章目录
获取表名+触发器名称+具体执行内容:
SELECT CONCAT(event_object_table,' ',trigger_name,' ',action_statement) as sqltext FROM information_schema.TRIGGERS
order by event_object_table
方便集中处理所有触发器;
获取表名+触发器名称+具体执行内容:
SELECT CONCAT(event_object_table,' ',trigger_name,' ',action_statement) as sqltext FROM information_schema.TRIGGERS
order by event_object_table
方便集中处理所有触发器;
评论
登录后参与技术讨论,分享你的经验与见解。
登录 / 注册暂无评论