Insert data rows into a table
After you create a table, insert rows of data into that table.
Note
The INSERT command inserts rows into a table. For standard bulk loads, use the COPY command. For more information, see Use a COPY command to load data.
For example, to insert values into the DEMO
table, run the following
command.
INSERT INTO DEMO VALUES (781, 'San Jose'), (990, 'Palo Alto');
To insert data into a table that's in a schema, run the following command.
INSERT INTO SALES.DEMO VALUES (781, 'San Jose'), (990, 'Palo Alto');