Reasons not to use stored procedures in databases

http://www.tonymarston.net/php-mysql/stored-procedures-are-evil.html

MySQL stored procedure gotchas

END and END IF statements must always end with a semicolon.

See stored procedures in MySQL

List them

mysql> show procedure status;

See the code of one

mysql> show create procedure [name];