Results 1 to 1 of 1
Thread: Stored Procedure issues
Apr 5, 2010, 15:52 #1
- Join Date
- Apr 2010
- 0 Post(s)
- 0 Thread(s)
Stored Procedure issues
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.
DROP PROCEDURE catalog_get_department_list;
but that didn't work.