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: Apr 15 2024
Copyright © 2024 Thunderstone Software LLC. All rights reserved.