Skip navigation links
MySQL 5.5 Reference Manual :: 19 INFORMATION_SCHEMA Tables :: 19.27 The INFORMATION_SCHEMA PARAMETERS Table
19.28 The INFORMATION_SCHEMA PROFILING Table »
Section Navigation      [Toggle]

19.27. The INFORMATION_SCHEMA PARAMETERS Table

The PARAMETERS table provides information about stored function and procedure parameters, and about return values for stored functions. Parameter information is similar to the contents of the param_list column in the mysql.proc table.

INFORMATION_SCHEMA Name mysql.proc Name Remarks
SPECIFIC_CATALOG   def
SPECIFIC_SCHEMA db routine database
SPECIFIC_NAME name routine name
ORDINAL_POSITION   1, 2, 3, ... for parameters, 0 for function RETURNS clause
PARAMETER_MODE   IN, OUT, INOUT (NULL for RETURNS)
PARAMETER_NAME   parameter name (NULL for RETURNS)
DATA_TYPE   same as for COLUMNS table
CHARACTER_MAXIMUM_LENGTH   same as for COLUMNS table
CHARACTER_OCTET_LENGTH   same as for COLUMNS table
NUMERIC_PRECISION   same as for COLUMNS table
NUMERIC_SCALE   same as for COLUMNS table
CHARACTER_SET_NAME   same as for COLUMNS table
COLLATION_NAME   same as for COLUMNS table
DTD_IDENTIFIER   same as for COLUMNS table
ROUTINE_TYPE type same as for ROUTINES table

Notes:

  • The PARAMETERS table was added in MySQL 5.5.3.

  • For successive parameters of a stored function or procedure, 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.

  • The ROUTINE_TYPE column was added in MySQL 6.0.5. (Bug#33106)