发布时间:2022-12-29 09:00
查看全部存储过程:
show procedure status;
查看某个数据库全部存储过程:
show procedure status where db='db_name';
查看某个存储过程详情:
show create procedure pro_name;
或
select `name` from mysql.proc where db = 'xx' and `type` = 'PROCEDURE'