Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 37.4Mb
PDF (A4) - 37.5Mb
PDF (RPM) - 33.2Mb
HTML Download (TGZ) - 8.3Mb
HTML Download (Zip) - 8.4Mb
HTML Download (RPM) - 7.3Mb
Man Pages (TGZ) - 130.0Kb
Man Pages (Zip) - 185.6Kb
Info (Gzip) - 3.3Mb
Info (Zip) - 3.3Mb


MySQL 8.0 Reference Manual  /  INFORMATION_SCHEMA Tables  /  The INFORMATION_SCHEMA PARAMETERS Table

Pre-General Availability Draft: 2018-02-24

25.12 The INFORMATION_SCHEMA PARAMETERS Table

The PARAMETERS table provides information about stored procedure and function parameters, and about return values for stored functions.

INFORMATION_SCHEMA NameRemarks
SPECIFIC_CATALOGdef
SPECIFIC_SCHEMAroutine database
SPECIFIC_NAMEroutine name
ORDINAL_POSITION1, 2, 3, ... for parameters, 0 for function RETURNS clause
PARAMETER_MODEIN, OUT, INOUT (NULL for RETURNS)
PARAMETER_NAMEparameter name (NULL for RETURNS)
DATA_TYPEsame as for COLUMNS table
CHARACTER_MAXIMUM_LENGTHsame as for COLUMNS table
CHARACTER_OCTET_LENGTHsame as for COLUMNS table
NUMERIC_PRECISIONsame as for COLUMNS table
NUMERIC_SCALEsame as for COLUMNS table
DATETIME_PRECISIONsame as for COLUMNS table
CHARACTER_SET_NAMEsame as for COLUMNS table
COLLATION_NAMEsame as for COLUMNS table
DTD_IDENTIFIERsame as for COLUMNS table
ROUTINE_TYPEsame as for ROUTINES table

Notes:

  • For successive parameters of a stored procedure or function, the ORDINAL_POSITION values are 1, 2, 3, and so forth. For a stored function, there is also a row that describes the data type for the RETURNS clause. The return value is not a true parameter, so the row that describes it has these unique characteristics:

    • The ORDINAL_POSITION value is 0.

    • The PARAMETER_NAME and PARAMETER_MODE values are NULL because the return value has no name and the mode does not apply.


User Comments
Sign Up Login You must be logged in to post a comment.