SQL SELECT INTO

SELECT INTO 把查询结果复制到一张新表；常用于备份或建中间表。

Intermediate

Key PointsSQL,SELECT INTO,备份,新表

讲解

SELECT INTO 把查询结果复制到一张新表；常用于备份或建中间表。

SQL

SELECT * INTO WebsitesBackup FROM Websites;

SELECT name, url
INTO SitesCN
FROM Websites
WHERE country = 'CN';

Output

(5 rows affected)   -- WebsitesBackup 已包含全部数据
(3 rows affected)   -- SitesCN 只含 CN 站点

SELECT INTO 把查询结果复制到一张新表；常用于备份或建中间表。

SQL

SELECT * INTO WebsitesBackup FROM Websites;

SELECT name, url
INTO SitesCN
FROM Websites
WHERE country = 'CN';

Output

(5 rows affected)   -- WebsitesBackup 已包含全部数据
(3 rows affected)   -- SitesCN 只含 CN 站点