SHOW Statements | Pos | Instruction | +-----+---------------------------------------+ | 0 | freturn 254 concat(’Hello, ’,s@0,’!’) | +-----+---------------------------------------+ 1 row in set (0.00 sec) In this example, the nonexecutable  BEGIN  and  END  statements have disappeared, and for the  DECLARE variable_name  statement, only the executable part appears (the part where the default is assigned). For each statement that is taken from source, there is a code word  stmt  followed by a type (9 means  DROP , 5 means  INSERT , and so on). The final row contains an instruction  jump 2 , meaning  GOTO instruction #2 . 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 13.7.7.20, “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 26.8, “Extensions to SHOW Statements” . mysql>  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. 2941 SHOW PROCEDURE STATUS [LIKE ’ pattern ’ | WHERE  expr ] 13.7.7.28 SHOW PROCEDURE STATUS Statement