How to view / view stored procedure in PhpMyAdmin

Question

I want to view or view the created stored procedure in PhpMyAdmin. I created 1 stored procedure and execute it as well, but how can I view or modify a specific stored procedure, is it possible or not, and explain how to use it correctly to create a stored procedure using PhpMyAdmin or what other methods (any other tool ) with stored procedures, I am new to MySql and PhpMyAdmin.

Please, help

Answer 1

Take a look at the info page. In your case, the routines table.

http://dev.mysql.com/doc/refman/5.1/en/routines-table.html

If you want to list all stored procedures, you can use this query

select * from information_schema.routines where routine_type = 'procedure' 

To limit the result to a specific database:

 select * from information_schema.routines where routine_type = 'procedure' and routine_schema = 'your_db' 

The contents of stored procedures can be found in the policy_definition field.

Also, take a look at:

 show create procedure stored_procedure_name 

You will find the contents of the stored procedure in the Create Procedure field.