Syntax
------ 
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.
 
Description
----------- 
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
 
Example
 
See example in PREPARE.
 


URL: https://mariadb.com/kb/en/execute-statement/