Inserting values into all columns of a row

You can insert values into all the columns of a row using the INSERT statement.

Prerequisites

You must have INSERT privilege on the table. If the ON EXISTING UPDATE clause is specified, UPDATE privilege on the table is also required.

Type the values in the same order as the column names in the original CREATE TABLE statement.

Surround the values with parentheses.

Enclose all character data in single quotes.

Use a separate INSERT statement for each row you add.

Results

The specified values are inserted into each column of a new row.

Example

The following INSERT statement adds a new row to the Departments table, giving a value for every column in the row:

INSERT INTO GROUPO.Departments
VALUES ( 702, 'Eastern Sales', 902 );