查看存储过程:
select * from mysql.proc where db = 'xx' and `type` = 'PROCEDURE'
show procedure status;
查看函数
select * from mysql.proc where db = 'xx' and `type` = 'FUNCTION'
show function status;
查看存储过程:
select * from mysql.proc where db = 'xx' and `type` = 'PROCEDURE'
show procedure status;
查看函数
select * from mysql.proc where db = 'xx' and `type` = 'FUNCTION'
show function status;