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;
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.