Add New Data

Use the insert command to add rows to a database.

To add rows using insert:

Use the values keyword to specify values for some or all of the columns in a new row. A simplified version of the syntax for the insert command using the values keyword is:
```
insert table_name 
     values (constant1, constant2, ...) 
```
You can use a select statement in an insert statement to pull values from one or more tables (up to a limit of 250 tables, including the table into which you are inserting). A simplified version of the syntax for the insert command using a select statement is:
```
insert table_name 
     select column_list 
     from table_list 
     where search_conditions
```
Note: You cannot use a compute clause in a select statement that is inside an insert statement, because statements that include compute do not generate normal rows.

When you add text, unitext, or image values with insert, all data is written to the transaction log. You can use the writetext command to add these values without logging the long chunks of data that may comprise text, unitext, or image values.

Add New Rows with Values
Use the insert statement to add rows and values for columns in the row.
Insert Data into Specific Columns
You can add data to some columns in a row by specifying only those columns and their data. All other columns that are not included in the column list must be defined to allow null values. The skipped columns can accept defaults. If you skip a column that has a default bound to it, the default is used.
Add New Rows with select
To add values to a table from one or more other tables, use a select clause in the insert statement. The select clause can insert values into some or all of the columns in a row.

Parent topic: Managing Data

Related concepts

Insert Data into Specific Columns