SQL SELECT INTO Statement
SQL SELECT INTO Statement
The SELECT INTO statement copies data from one table into a new table.
SELECT INTO 語法
將所有列複製到新表中
SELECT *
INTO newtable [IN externaldb]
FROM oldtable
WHERE condition;將部分列複製到新表中
SELECT column1, column2, column3, ...
INTO newtable [IN externaldb]
FROM oldtable
WHERE condition;新表將根據舊錶的列名和型別建立。您可以使用 AS 子句建立新的列名。
SQL 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;
提示: SELECT INTO 也可以用來建立一個新的空表，其結構與另一個表相同。只需新增一個會導致查詢不返回任何資料的 WHERE 子句即可。
SELECT * INTO newtable
FROM oldtable
WHERE 1 = 0;
