查看存储过程或者函数的详细信息如下三种方式
1 .show create function 函数名字;
2. show procedure status like '%show_salary%';
3.select * from information_schema.Routines where routine_name = 'show_salary'
举例:
select * from information_schema.Routines order by created desc limit 10
这条语句可以查看创建的存储过程或者函数的详细信息
select * from information_schema.Routines where routine_name = 'show_salary' and routine_type = 'PROCEDURE'