Home / code / sql

Insert into a new table

With this you can make a new table based on the selected records.

SELECT fields INTO newtable [IN externdatabase] FROM source

Part Explanation
field1, field2 The names of the fields that must be copied to the new table.
newtable The name of the table that should be made. The name must comply to the rules, it cannot have the same name as any other table.
externdatabase The path to another database
source The name of the existing table from where the records are selected. 1 table, more tables or query.

You can also use INSERT INTO to add records to a table.

 

TOP

Latest script:

 

Books: