INSERT INTO SELECT命令從一個表中復制數(shù)據(jù)并將其插入到另一個表中。
以下SQL將“供應商(Suppliers)”復制到“客戶(Customers )”中（未填充數(shù)據(jù)的列將包含NULL）：
INSERT INTO Customers (CustomerName, City, Country) SELECT SupplierName, City, Country FROM Suppliers;
以下SQL將“供應商(Suppliers)”復制到“客戶(Customers )”中（填寫所有列）：
INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country) SELECT SupplierName, ContactName, Address, City, PostalCode, Country FROM Suppliers;
以下SQL僅將德國供應商復制到“客戶(Customers )”中：
INSERT INTO Customers (CustomerName, City, Country) SELECT SupplierName, City, Country FROM Suppliers WHERE Country='Germany';