> ## Documentation Index
> Fetch the complete documentation index at: https://docs.peaka.com/llms.txt
> Use this file to discover all available pages before exploring further.

# PREPARE

## Synopsis

```text theme={null}
PREPARE statement_name FROM statement
```

## Description

Prepares a statement for execution at a later time. Prepared statements are
queries that are saved in a session with a given name. The statement can
include parameters in place of literals to be replaced at execution time.
Parameters are represented by question marks.

## Examples

Prepare a select query:

```sql theme={null}
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 [EXECUTE](/sql/reference/execute) statement:

```sql theme={null}
PREPARE my_select2 FROM
SELECT name FROM nation WHERE regionkey = ? AND nationkey < ?;
```

Prepare an insert query:

```sql theme={null}
PREPARE my_insert FROM
INSERT INTO cities VALUES (1, 'San Francisco');
```

## See also

[EXECUTE](/sql/reference/execute)