List of Stored Procedures/Functions Mysql Command Line

Question

Dear all 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 1

SHOW PROCEDURE STATUS
SHOW FUNCTION STATUS

Answer 2

show procedure status

will show you the stored procedures.

show create procedure MY_PROC

will show you the definition of a procedure. And

help show

will show you all the available options for the show command.

Answer 3

SHOW PROCEDURE STATUS;