SQL INSERT INTO SELECT
·
The INSERT
INTO SELECT statement copies data from one table and inserts it into
another table.
·
The INSERT
INTO SELECT statement requires that the data types in source and target
tables match.
INSERT
INTO SELECT Syntax
Copy
all columns from one table to another table:
INSERT INTO table2
SELECT * FROM table1
WHERE condition;
Copy
only some columns from one table into another table:
INSERT INTO table2 (column1, column2, column3,
...)
SELECT column1, column2, column3,
...
FROM table1
WHERE condition;
SQL INSERT
INTO SELECT Examples
The following SQL statement copies "Suppliers" into "Customers" (the columns that are not filled with data, will contain NULL):
INSERT INTO
Customers (CustomerName, City, Country)
SELECT SupplierName, City, Country FROM Suppliers;
The following SQL statement copies "Suppliers" into "Customers" (fill all columns):
Example
INSERT INTO
Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
SELECT SupplierName, ContactName, Address, City, PostalCode, Country FROM Suppliers;
The following
SQL statement copies only the German suppliers into "Customers":
Example
INSERT INTO
Customers (CustomerName, City, Country)
SELECT SupplierName, City, Country FROM Suppliers
WHERE Country='Germany';
0 Comments