======= PREPARE ======= Synopsis -------- .. code-block:: none PREPARE statement_name FROM statement Description ----------- Prepares a statement for execution later. Prepared statements are queries that are saved on a per-session basis with a given name. The statement can include parameters in place of literals to be filled in at execution time. Parameters are represented by question marks. Examples -------- Prepare a select query: .. code-block:: sql PREPARE my_select1 FROM SELECT * FROM nation; Prepare a select query that includes parameters. The values to compare with ``regionkey`` and ``nationkey`` will be filled in with the :doc:`execute` statement: .. code-block:: sql PREPARE my_select2 FROM SELECT name FROM nation WHERE regionkey = ? AND nationkey < ?; Prepare an insert query: .. code-block:: sql PREPARE my_insert FROM INSERT INTO cities VALUES (1, 'San Francisco'); See Also -------- :doc:`execute`, :doc:`deallocate-prepare`, :doc:`describe-input`, :doc:`describe-output`