Re: listing store procedures

[Andrew Gilfrin]

There are 3 methods you can use to get procedure metadata, SHOW, the information schema or mysql.proc.

The easiest way is to use something like.

mysql> select routine_name from information_schema.routines;
+----------------+
| routine_name |
+----------------+
| helloworld |
+----------------+
1 row in set (0.24 sec)

You can check out the various methods in more detail in the MySQL documentation or for an overview here...

http://mysql.gilfster.com/page.php?parent_id=1.1&page_id=1.1.8

Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog

http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information