查询MySQL中的存储过程和函数

select name from mysql.proc where db = ‘‘ and `type` = ‘PROCEDURE‘ //查询存储过程

select name from mysql.proc where db = ‘‘ and `type` = ‘FUNCTION‘ //查询函数

select name,body_utf8 from mysql.proc where db = ‘‘ and `type` = ‘PROCEDURE‘ and name=‘‘;

查询MySQL中的存储过程和函数

标签：mysql   函数   存储过程   查询