sql SELECT INTO

The SELECT INTO statement is used to create copies of tables as a backup.
This statement selects data from one table and inserts it into a different table.

SQL SELECT INTO Syntax

Syntax in selecting all columns into new table:

SELECT * INTO myNewTable [IN myExternalDatabse]
FROM myOldTable


Syntax in selecting specific columns into new table:

SELECT myColumn(s) INTO myNewTable [IN myExternalDatabse]
FROM myOldTable


Single Post Navigation

← Older Entry

Newer Entry →