Creates a SQL statement with the name statement_name to be run at a later
time. The statement can include parameters represented by question marks. To supply values
for the parameters and run the prepared statement, use EXECUTE.
Synopsis
PREPARE statement_name FROM statementThe following table describes the parameters.
| Parameter | Description |
|---|---|
statement_name |
The name of the statement to be prepared. The name must be unique within the workgroup. |
statement |
A SELECT, CTAS, or INSERT INTO
query. |
Note
The maximum number of prepared statements in a workgroup is 1000.
Examples
The following example prepares a select query without parameters.
PREPARE my_select1 FROM
SELECT * FROM nationThe following example prepares a select query that includes parameters. The values for
productid and quantity will be supplied by the
USING clause of an EXECUTE statement:
PREPARE my_select2 FROM
SELECT order FROM orders WHERE productid = ? and quantity < ?The following example prepares an insert query.
PREPARE my_insert FROM
INSERT INTO cities_usa (city, state)
SELECT city, state
FROM cities_world
WHERE country = ?Additional resources
