(mysql.info) show-procedure-status

 
 13.5.4.18 `SHOW PROCEDURE STATUS' and `SHOW FUNCTION STATUS' Syntax
 ...................................................................
 
      SHOW {PROCEDURE | FUNCTION} STATUS [LIKE 'PATTERN']
 
 This statement is a MySQL extension. It returns characteristics of
 routines, such as the database, name, type, creator, and creation and
 modification dates. If no pattern is specified, the information for all
 stored procedures or all stored functions is listed, depending on which
 statement you use.
 
      mysql> SHOW FUNCTION STATUS LIKE 'hello'\G
      *************************** 1. row ***************************
                 Db: test
               Name: hello
               Type: FUNCTION
            Definer: testuser@localhost
           Modified: 2004-08-03 15:29:37
            Created: 2004-08-03 15:29:37
      Security_type: DEFINER
            Comment:
 
 You can also get information about stored routines from the `ROUTINES'
 table in `INFORMATION_SCHEMA'. See  routines-table.

Info Catalog

(mysql.info) show-privileges

(mysql.info) show

(mysql.info) show-processlist

automatically generated byinfo2html