一、select * into 用法:应用于表的复制、备份
select *
into persons_bak
from persons
二、IN 子句可用于向另一个数据库中拷贝表:
select *
into persons IN 'backup.mdb'
from persons
三、如果希望拷贝某些列,可以在 SELECT 语句后列出这些列:
SELECT Lastname,FirstName
INTO persons_bak
FROM persons
四、where语句
select LastName,FirstName
INTO persons_bak
FROM persons
WHERE City='Zhengzhou'