跳转至

SQL SELECT INTO

SELECT INTO 通常用于把查询结果写入一张新表。

示例

SELECT *
INTO customers_backup
FROM customers;

条件复制

SELECT name, city
INTO beijing_customers
FROM customers
WHERE city = 'Beijing';

方言差异

  • SQL Server 常见 SELECT INTO
  • MySQL 常更常见 CREATE TABLE ... AS SELECT ...

相关链接