Inserting Multiple Rows at a Time

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] ;

Copyright © Thunderstone Software     Last updated: Jun 15 2022
Copyright © 2022 Thunderstone Software LLC. All rights reserved.