Run a previously prepared statement. This command executes the statement using the specified name, optionally supplying input parameters.
After preparing a statement with PREPARE, you execute it with anEXECUTE statement that refers to the prepared statement name. If the prepared statement contains any parameter markers, you must supply aUSING clause that lists expressions containing the values to be bound to the parameters. The USING clause must name exactly as many expressions as the number of parameter markers in the statement.
You can execute a given prepared statement multiple times, passing different variables to it or setting the variables to different values before each execution.
If the specified statement has not been PREPAREd, an error similar to the following is produced:
EXECUTE with arbitrary expression as parameters can be used, not just user variables (@var_name).
You can only use user variables (@var_name) as parameters.
See .
This page is licensed: GPLv2, originally from
EXECUTE stmt_name
[USING expression[, expression] ...]ERROR 1243 (HY000): Unknown prepared statement handler (stmt_name) given to EXECUTE