MySQL存储过程查询

查询存储过程

select * from information_schema.ROUTINES\G

mysql> select * from information_schema.routines where routine_schema='world'\G

查询存储过程的创建语句

mysql> show create procedure world.p_iterate;

 

删除存储过程

drop procedure procedure_name;

 早期版本查看存储过程

   select `name` from mysql.proc where db = 'xx' and `type` = 'PROCEDURE'   //存储过程

   select * from mysql.proc where db = 'xx' and `type` = 'PROCEDURE' and name='xx'

查看存储过程状态

show procedure status; //存储过程