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';