Insert some column values in a row

If you want to insert a row without providing values for all of the columns in a row, you can use a list of columns with the INSERT statement.

Specify the values you want to insert into the columns, as in this example:

INSERT INTO PERS (ID, NAME, JOB, SALARY)
VALUES (510, 'BUCHANAN', 'CLERK', 11500.75)

An easy way to create an INSERT query is by using the DRAW command with the option, (TYPE=INSERT. Columns for which values are not specified are given no value (NULL). If a column is defined as NOT NULL, you must specify values for it.