SQL INSERT INTO SELECT 关键字

INSERT INTO SELECT

INSERT INTO SELECT 命令从一个表中复制数据，并将其插入到另一个表中。

以下 SQL 将 "Suppliers" 的数据复制到 "Customers"（未填充数据的列将包含 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';