New to PHP/MySQL and not very certain of how to work with Stored Procedures.
I am using MAMP and phpMyAdmin. My database name is ‘tshirtshop’.
When I created a stored procedure the only way I can see it in MySQL is to look in the ROUTINES view under the information_schema. (It does not appear in phpMyAdmin under my database.)
Here are some questions…
1.) Is there a more logical way to see all stored procedures associated with a database?
2.) How do I drop a stored procedure?
I made a type-o, and need to get rid of ‘catalog_get_department_list’ but don’t know how.
I tried…
DROP PROCEDURE catalog_get_department_list;
but that didn’t work.
Sincerely,
TomTees