Press CTRL+C to copySHOW PROCEDURE STATUS [LIKE 'pattern' | WHERE expr]
This statement is a MySQL extension. It returns characteristics
of a stored procedure, such as the database, name, type,
creator, creation and modification dates, and character set
information. A similar statement, SHOW
FUNCTION STATUS
, displays information about stored
functions (see Section 15.7.7.21, “SHOW FUNCTION STATUS Statement”).
To use either statement, you must be the user named as the
routine DEFINER
, have the
SHOW_ROUTINE
privilege, have the
SELECT
privilege at the global
level, or have the CREATE
ROUTINE
, ALTER ROUTINE
,
or EXECUTE
privilege granted at a
scope that includes the routine.
The LIKE
clause, if present,
indicates which procedure or function names to match. The
WHERE
clause can be given to select rows
using more general conditions, as discussed in
Section 28.8, “Extensions to SHOW Statements”.
Press CTRL+C to copymysql> SHOW PROCEDURE STATUS LIKE 'sp1'\G *************************** 1. row *************************** Db: test Name: sp1 Type: PROCEDURE Definer: testuser@localhost Modified: 2018-08-08 13:54:11 Created: 2018-08-08 13:54:11 Security_type: DEFINER Comment: character_set_client: utf8mb4 collation_connection: utf8mb4_0900_ai_ci Database Collation: utf8mb4_0900_ai_ci mysql> SHOW FUNCTION STATUS LIKE 'hello'\G *************************** 1. row *************************** Db: test Name: hello Type: FUNCTION Definer: testuser@localhost Modified: 2020-03-10 11:10:03 Created: 2020-03-10 11:10:03 Security_type: DEFINER Comment: character_set_client: utf8mb4 collation_connection: utf8mb4_0900_ai_ci Database Collation: utf8mb4_0900_ai_ci
character_set_client
is the session value of
the character_set_client
system
variable when the routine was created.
collation_connection
is the session value of
the collation_connection
system
variable when the routine was created. Database
Collation
is the collation of the database with which
the routine is associated.
Stored routine information is also available from the
INFORMATION_SCHEMA
PARAMETERS
and
ROUTINES
tables. See
Section 28.3.20, “The INFORMATION_SCHEMA PARAMETERS Table”, and
Section 28.3.30, “The INFORMATION_SCHEMA ROUTINES Table”.