Execute

来源:华为浏览 215 扫码分享 2020-07-04 09:02:30

EXECUTE

EXECUTE statement_name [ USING parameter1 [ , parameter2, ... ] ]

Executes a prepared statement with the name statement_name. Parameter values are defined in the USING clause.

Prepare and execute a query with no parameters:

PREPARE my_select1 FROM
SELECT name FROM nation;

EXECUTE my_select1;

Prepare and execute a query with two parameters:

PREPARE my_select2 FROM
SELECT name FROM nation WHERE regionkey = ? and nationkey < ?;

EXECUTE my_select2 USING 1, 3;

This is equivalent to:

SELECT name FROM nation WHERE regionkey = 1 AND nationkey < 3;