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