Adding rows to a table

ASA Getting Started
Updating the Database

Adding rows to a table

Suppose that the company decides to sell a new product, a brown acrylic vest. This action requires you to add data to the product table of the sample database.

Add a brown acrylic vest to the product table

In Interactive SQL, type the following in the SQL Statements pane and press F5 to execute the statement.
```
INSERT
INTO product ( id, name, description, size, color,
               quantity, unit_price )
VALUES ( 800, 'Vest', 'Acrylic Vest', 'Extra Large',
         'Brown', 42, 20.00 )
```
If you make a mistake and forget to specify one of the columns, Adaptive Server Anywhere reports an error.

You can also add new rows to database tables from the result set in Interactive SQL.

For more information, see Editing table values in Interactive SQL.

NULL values in columns

The NULL value is a special value used to indicate that something is either not known or not applicable. Some columns are allowed to contain the NULL value, and others are not.