方法一:
select `name` from mysql.proc where db = ‘your_db_name‘ and `type` = ‘PROCEDURE‘
方法二:
show procedure status;
show create procedure proc_name;show create function func_name;
mysql存储过程相关
原文:http://www.cnblogs.com/khoe/p/7462610.html