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;