How do I view my stored procedures in phpMyAdmin?
View stored procedures in phpmyadmin:
Query:
SELECT routine_definitionFROM information_schema.routinesWHERE routine_name = 'procedure_name' AND routine_schema = 'databasename';Here's how to get there in phpmyadmin.
The routines option is available in phpmyadmin. The link is not visible in PHPmyadmin until you have at least one stored procedure. See the above image and click the routines link under structure tab.
select routine_definitionfrom information_schema.routineswhere routine_schema = 'db_name'and routine_name = 'sp_name';
This answer shows how to view them without a script.
"Once you created the stored procedure it will appear in the Routines fieldset below your tables (in the Structure tab), and you can easily change/drop it."