IBM PureData System for Analytics, Version 7.1

Insert rows into a table

To populate a table, use the INSERT command. The INSERT command adds new rows to a table. You can insert rows by using column positions, column names, or by inserting rows from one table to another.

The following example inserts a row into the table weather:

MYDB.SCHEMA(USER)=> INSERT INTO weather VALUES ('San Francisco', 46, 50, 
0.25, '1994-11-27');

To insert by using column names, enter:

MYDB.SCHEMA(USER)=> INSERT INTO weather (city, temp_lo, temp_hi, prcp, 
date) VALUES ('San Francisco', 43, 57, 0.0, '1994-11-29');

When you use columns names, you can list them in any order and you can omit columns for which you do not have data:

MYDB.SCHEMA(USER)=> INSERT INTO weather (date, city, temp_hi, temp_lo) 
VALUES ('1994-11-29', 'Hayward', 54, 37);