SELECT INTO 將查詢結果直接建立新表,適用快速備份、建立報表暫存表、跨資料庫複製。
SELECT * INTO new_table [IN external_db] FROM old_table;
SELECT col1, col2 INTO new_table FROM old_table WHERE condition;
SELECT * INTO Persons_Backup FROM Persons;
SELECT * INTO Persons_Backup IN 'Backup.mdb' FROM Persons;
SELECT LastName, FirstName INTO Persons_Backup FROM Persons;
SELECT LastName, FirstName INTO Persons_Backup
FROM Persons WHERE City = 'Sandnes';
SELECT Persons.LastName, Orders.OrderNo
INTO Persons_Order_Backup
FROM Persons
INNER JOIN Orders ON Persons.P_Id = Orders.P_Id;
CREATE TABLE new_table AS SELECT ...。IN 子句僅 Access/SQL Server 支援。CREATE TABLE Persons_Backup AS SELECT * FROM Persons;
CREATE TABLE Persons_Backup AS SELECT LastName, FirstName FROM Persons WHERE City='Sandnes';