EXECUTE IMMEDIATE#

Synopsis#

EXECUTE IMMEDIATE `statement` [ USING parameter1 [ , parameter2, ... ] ]
Copy to clipboard

Description#

Executes a statement without the need to prepare or deallocate the statement. Parameter values are defined in the USING clause.

Examples#

Execute a query with no parameters:

EXECUTE IMMEDIATE
'SELECT name FROM nation';
Copy to clipboard

Execute a query with two parameters:

EXECUTE IMMEDIATE
'SELECT name FROM nation WHERE regionkey = ? and nationkey < ?'
USING 1, 3;
Copy to clipboard

This is equivalent to:

PREPARE statement_name FROM SELECT name FROM nation WHERE regionkey = ? and nationkey < ?
EXECUTE statement_name USING 1, 3
DEALLOCATE PREPARE statement_name
Copy to clipboard

See also#

EXECUTE, PREPARE, DEALLOCATE PREPARE