SQL SELECT INTO 语句
SQL SELECT INTO 语句
SELECT INTO 语句将数据从一个表复制到一个新表中。
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语句创建客户的备份副本:
SELECT * INTO CustomersBackup2017
FROM Customers;以下SQL语句使用IN子句将表复制到另一个数据库中的新表中:
SELECT *
INTO CustomersBackup2017 IN 'Backup.mdb'
FROM Customers;以下SQL语句仅将几列复制到新表中:
SELECT CustomerName, ContactName INTO CustomersBackup2017
FROM Customers;以下SQL语句仅将 Germany 客户复制到新表中:
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;
