I'm not able to view subprocedures in Phpmyadmin. I have created a sub procedure via the execute query option. Is there an option to list the subprocedure and edit them.

2 Answers 2

show procedure status

will show you the stored procedures.

show create procedure MY_PROC

will show you the definition of a procedure. And

help show

will show you all the available options for the show command.

This will work in phpmyadmin.


No. Although on the Phpmyadmin home page it says it supports them there is no easy way to edit them. This is a feature request on the phpmyadmin wiki and in sourceforge but it doesn't look like anyone's implemented it.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.