10.28. INSERT

    If the list of column names is specified, they must exactly match the list of columns produced by the query. Each column in the table not present in the column list will be filled with a value. Otherwise, if the list of columns is not specified, the columns produced by the query must exactly match the columns in the table being inserted into.

    1. INSERT INTO orders

    Insert a single row into the cities table:

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

    Insert a single row into the table with the specified column list:

    1. INSERT INTO nation (nationkey, name, regionkey)

    VALUES