Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

SQL INSERT INTO SELECT Keyword

Concept visual

SQL INSERT INTO SELECT Keyword

Pointer walk

two pointers

left=0

right=6

Start at both ends

INSERT INTO SELECT Keyword

❮ SQL Keywords

Insert Into Select

The INSERT INTO SELECT

command copies data from one table and inserts it into another table. The following SQL copies "Suppliers" into "Customers" (the columns that are not filled with data, will contain NULL):

Example

INSERT INTO Customers (CustomerName, City, Country)

SELECT SupplierName, City, Country FROM Suppliers;
The following SQL 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 copies only the German suppliers into "Customers":

Example

INSERT INTO Customers (CustomerName, City, Country) SELECT SupplierName, City, Country FROM Suppliers

WHERE Country='Germany';

❮ SQL Keywords

SQL INSERT INTO Keyword

SQL IS NULL Keyword

Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

SQL INSERT INTO SELECT Keyword

Concept visual

SQL INSERT INTO SELECT Keyword

Pointer walk

two pointers

left=0

right=6

Start at both ends

INSERT INTO SELECT Keyword

❮ SQL Keywords

Insert Into Select

The INSERT INTO SELECT

command copies data from one table and inserts it into another table. The following SQL copies "Suppliers" into "Customers" (the columns that are not filled with data, will contain NULL):

Example

INSERT INTO Customers (CustomerName, City, Country)

SELECT SupplierName, City, Country FROM Suppliers;
The following SQL 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 copies only the German suppliers into "Customers":

Example

INSERT INTO Customers (CustomerName, City, Country) SELECT SupplierName, City, Country FROM Suppliers

WHERE Country='Germany';

❮ SQL Keywords

SQL INSERT INTO Keyword

SQL IS NULL Keyword

SQL INSERT INTO SELECT Keyword

SQL INSERT INTO SELECT Keyword

INSERT INTO SELECT Keyword

Previous

Next

Insert Into Select

The INSERT INTO SELECT

Example

Example

Country)

Example

Previous

Next

SQL INSERT INTO SELECT Keyword

SQL INSERT INTO SELECT Keyword

INSERT INTO SELECT Keyword

Previous

Next

Insert Into Select

The INSERT INTO SELECT

Example

Example

Country)

Example

Previous

Next