Presto 101t Documentation

8.9. INSERT

8.9. INSERT

Synopsis

INSERT INTO table_name query

Description

Insert new rows into a table.

Note

Currently, the list of column names cannot be specified. Thus, the columns produced by the query must exactly match the columns in the table being inserted into.

Examples

Load additional rows into the orders table from the new_orders table:

INSERT INTO orders
SELECT * FROM new_orders;

Insert a single row into the cities table:

INSERT INTO cities VALUES (1, 'San Francisco');

Insert multiple rows into the cities table:

INSERT INTO cities VALUES (2, 'San Jose'), (3, 'Oakland');