W3Schools SQL | #30 SQL SELECT INTO 구문

SQL SELECT INTO Statement

The SQL SELECT INTO Statement

한 테이블의 데이터를 다른 테이블로 복사한다.

SELECT INTO Syntax

SELECT *
INTO newtable [IN externaldb]
FROM oldtable
WHERE condition;

모든 column을 다른 테이블에 복사하고 싶은 경우

SELECT column1, column2, ...
INTO newtable [IN externaldb]
FROM oldtable
WHERE condition;

일부 column만 다른 테이블에 복사하고 싶은 경우

SQL SELECT INTO Examples

SELECT * INTO CustomersBackup2017
FROM Customers;

SELECT * INTO CustomersBackup2017 IN 'Backup.mdb'
FROM Customers;

SELECT CustomerName, ContactName INTO CustomersBackup2017
FROM Customers;

SELECT * INTO CustomersGermany
FROM Customers
WHERE Country = 'Germany';

SELECT Customers.CustomerName, Orders.OrderID
INTO CustomersOrderBackup2017
FROM Customers
LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;

SELECT * INTO newtable
FROM oldtable
WHERE 1 = 0;