Name
SHOW PROCEDURE STATUS
Synopsis
SHOW PROCEDURE STATUS [LIKE 'pattern
'|WHEREexpression
]
This statement displays information on stored procedures. The
LIKE
or WHERE
clauses can be
used to list stored procedures based on a particular naming pattern.
With the WHERE
clause, you can use the
names of fields in the results to create an expression that sets a
condition determining the results returned. Here is an example using
this statement:
SHOW PROCEDURE STATUS WHERE Name='students_copy_proc' \G *************************** 1. row *************************** Db: college Name: students_copy_proc Type: PROCEDURE Definer: russell@localhost Modified: 2007-11-27 09:27:42 Created: 2007-11-27 09:27:42 Security_type: DEFINER Comment:
Note that for the WHERE
clause we use the
field name to get the specific stored procedure.
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.