ASA SQL User's Guide
  Adding, Changing, and Deleting Data
    Adding data using INSERT

Inserting values into all columns of a row

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

INSERT INTO department
VALUES ( 702, 'Eastern Sales', 902 )

Notes 

• Type the values in the same order as the column names in the original CREATE TABLE statement, that is, first the ID number, then the name, then the department head ID.

• Surround the values by parentheses.

• Enclose all character data in single quotes.

• Use a separate insert statement for each row you add.