In addition to adding values to a table one row at a time, you can
also use a variation of the INSERT
command to load some or all data
from one table into another table. The second form of the INSERT
command is used when you want to create a new table based on the
results of a query against an existing table. The form of this INSERT
command is:
INSERT INTO table-name
SELECT expression1 [,expression2] ...
FROM table-name
[WHERE search-condition] ;