SQL SELECT INTO 關鍵字
SELECT INTO
SELECT INTO 命令將資料從一個表複製到新表中。
以下 SQL 語句建立 Customers 的備份副本
SELECT * INTO CustomersBackup2017
FROM Customers;以下 SQL 語句使用 IN 子句將表複製到另一個數據庫中的新表中
SELECT * INTO CustomersBackup2017 IN 'Backup.mdb'
FROM Customers;以下 SQL 語句僅複製幾列到新表中
SELECT CustomerName, ContactName INTO CustomersBackup2017
FROM Customers;以下 SQL 語句僅將德國的客戶複製到一個新表中
SELECT * INTO CustomersGermany
FROM Customers
WHERE Country = 'Germany';以下 SQL 語句將來自多個表的資料複製到一個新表中
SELECT Customers.CustomerName, Orders.OrderID
INTO CustomersOrderBackup2017
FROM Customers
LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;
