MySQL Bugs: #2458: SHOW PROCEDURE STATUS for a specific database

Bug #2458	SHOW PROCEDURE STATUS for a specific database
Submitted:	20 Jan 2004 6:42	Modified:	28 Nov 2005 9:29
Reporter:	Ivan Monnier	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:	5.0.0 alpha	OS:	Linux (Linux)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
SHOW PROCEDURE STATUS could have an option to list the procedures for a specific database. Today all procedures from all databases are listed.

How to repeat:
Issue SHOW PROCEDURE STATUS with several databases containing stored procedures. They are all listed.

Thank you for a feature request. I do not think, though, that this statement will be changed. It is possible to get the status information for tables from particular database only using the INFORMATION_SCHEMA.ROUTINE table. See http://dev.mysql.com/doc/refman/5.0/en/routines-table.html for details.