Adding new data

You can use the insert command to add rows to the database in two ways; with the values keyword or with a select statement:

The values keyword specifies 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 16 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 
```