EXECUTE stmt_name [USING expression[, expression] ...]
EXECUTE
with expression as parameters was introduced in MariaDB 10.2.3. Before that one could only use variables (@var_name) as parameters.
After preparing a statement with PREPARE
, you execute it with an EXECUTE
statement that refers to the prepared statement name. If the prepared statement contains any parameter markers, you must supply a USING
clause that lists user variables containing the values to be bound to the parameters. Parameter values can be supplied only by user variables, and the USING
clause must name exactly as many variables 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:
ERROR 1243 (HY000): Unknown prepared statement handler (stmt_name) given to EXECUTE
See example in PREPARE.
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/execute-statement/