Updated on 2022-11-18 GMT+08:00

DESCRIBE INPUT

Syntax

DESCRIBE INPUT statement_name

Description

This statement is used to list the input parameters of the prepared statement, parameter positions, and the type of each input parameter. Unknown is displayed if the parameter type is not determined.

Example

  • The following statement is used to prepare a precompiled statement with three input parameters and list the parameters of the precompiled statement.
    PREPARE my_select1 FROM SELECT ? FROM fruit WHERE name  = ? AND price < ?;
    DESCRIBE INPUT my_select1;
  • A precompiled statement without input parameters:
    PREPARE my_select2 FROM SELECT * FROM fruit;
    DESCRIBE INPUT my_select2;