show procedure status;

使用此命令可以查看数据库中的所有过程

用这个:

SHOW PROCEDURE STATUS;

我最喜欢呈现的程序列表的当前数据库:名称，参数列表，注释

SELECT specific_name AS name, param_list AS params, `comment`
FROM mysql.proc
WHERE db = DATABASE()
AND type = 'PROCEDURE';

为函数添加返回值:

SELECT specific_name AS name, param_list AS params, `returns`, `comment`
FROM mysql.proc
WHERE db = DATABASE()
AND type = 'FUNCTION';

如上所述，

show procedure status;

确实会显示过程列表，但会显示服务器范围内的所有过程。

如果你想只看到一个数据库中的那些，试试这个:

SHOW PROCEDURE STATUS WHERE Db = 'databasename';

SELECT specific_name FROM `information_schema`.`ROUTINES` WHERE routine_schema='database_name'

Praveenkumar_V帖子的一个变种:

SELECT `name` FROM mysql.proc WHERE db = 'dbname' AND `type` = 'PROCEDURE';
SELECT `name` FROM mysql.proc WHERE db = 'dbname' AND `type` = 'FUNCTION';

．．这是因为我在做家务之后需要节省时间:

SELECT CONCAT(
     "GRANT EXECUTE ON PROCEDURE `"
    ,`name`
    ,"` TO username@'%'; -- "
    ,`comment`
)
FROM mysql.proc
WHERE db = 'dbname'
AND `type` = 'PROCEDURE';

SELECT CONCAT(
     "GRANT EXECUTE ON FUNCTION `"
    ,`name`
    ,"` TO username@'%'; -- "
    ,`comment`
)
FROM mysql.proc
WHERE db = 'dbname'
AND `type` = 'FUNCTION';