mysql在查询分析器中查询所有触发器及其详细信息
1.SELECT * FROM information_schema.TRIGGERS;
2.show triggers;
mysql在查询分析器中查询所有存储过程
1.select 8 from mysql.proc where db= '数据库名' and type = 'procedure';
2.show procedure status;
mysql在查询分析器中查询所有触发器及其详细信息
1.SELECT * FROM information_schema.TRIGGERS;
2.show triggers;
mysql在查询分析器中查询所有存储过程
1.select 8 from mysql.proc where db= '数据库名' and type = 'procedure';
2.show procedure status;