Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
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.
show procedure status
will show you the stored procedures.
show create procedure MY_PROC
will show you the definition of a procedure. And
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.
Required, but never shown