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