List of Stored Procedures/Functions Mysql Command Line

mysql stored-procedures command-line
systemsfault picture systemsfault · Apr 9, 2009 · Viewed 559.4k times · Source

How can I see the list of the stored procedures or stored functions in mysql command line like show tables; or show databases; commands.

Answer

fredrik picture fredrik · Apr 9, 2009 
SHOW PROCEDURE STATUS;
SHOW FUNCTION STATUS;

Related questions

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

Error message on MySql: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' I have gone through several other posts and was not able to solve this problem. The part affected is …

Read More
How do you debug MySQL stored procedures?

My current process for debugging stored procedures is very simple. I create a table called "debug" where I insert variable values from the stored procedure as it runs. This allows me to see the value of any variable at a …

Read More
How to call a MySQL stored procedure from within PHP code?

I have stored procedure that I created in MySQL and want PHP to call that stored procedure. What is the best way to do this? -MySQL client version: 4.1.11 -MySQL Server version: 5.0.45 Here is my stored procedure: DELIMITER $$ DROP FUNCTION IF …

Read More