SQL专项练习1

SELECT INTO 语句从一个表中选取数据，然后把数据插入另一个表中。

SELECT INTO 语句常用于创建表的备份复件或者用于对记录进行存档。

如果插入的目标表不存在，则自动创建

SELECT * &  column_name(s)
INTO new_table_name [IN externaldatabase] 
FROM old_tablename

SELECT *
INTO Persons_backup
FROM Persons

SELECT *
INTO Persons IN 'Backup.mdb'
FROM Persons

SELECT LastName,Firstname
INTO Persons_backup
FROM Persons
WHERE City='Beijing'


SELECT Persons.LastName,Orders.OrderNo
INTO Persons_Order_Backup
FROM Persons
INNER JOIN Orders
ON Persons.Id_P=Orders.Id_P