Inserting One Row at a Time

In addition to initially loading data into tables, records can be added at any time to keep a table current. For example, if a new employee is hired, a new record, or row, would be added to the EMPLOYEE table. The INSERT command is used to enter a row into a table. The command has two formats:

1. Entering one row at a time.

2. Entering multiple rows at a time.

In the first format, the user enters values one row at a time, using the following version of the INSERT command:

     INSERT INTO  table-name [(column-name1 [,column-name2] ... )]
     VALUES  (value1, value2 ... ) ;

• Command Discussion