NYCPHP Meetup

[Hans Zaunere]

> Trying to figure 2 things out ...
> 
> * Is there anyway to create a *global* function for use w/ all tables?
> (if so, how?)

This might be stating the obvious, but these functions should do it:

http://dev.mysql.com/doc/mysql/en/CREATE_PROCEDURE.html

> * I thought you could get all the stored procedures like:
> 
> select create procedure *;
> 
> But it does not seem to work .. is
> 
> select name,body from mysql.proc; the "correct" way of doing this type
> of query?

You could also:

http://dev.mysql.com/doc/mysql/en/SHOW_PROCEDURE_STATUS.html

Something like:

SHOW PROCEDURE STATUS LIKE '%';

H