Take the 2-minute tour ×
Webmasters Stack Exchange is a question and answer site for pro webmasters. It's 100% free, no registration required.

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.

share|improve this question
add comment

2 Answers 2

up vote 2 down vote accepted
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.

share|improve this answer
add comment

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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