select `name` from mysql.proc where db = 'your_db_name' and `type` = 'PROCEDURE' show procedure status;
来源: http://www.phpxs.com/code/1008536/