SQL Select Into语句

The SELECT INTO Statement
SELECT INTO 语句

The SELECT INTO statement is most often used to create backup copies of tables or for archiving records.
SELECT INTO语句常用来给数据表建立备份或是历史档案。

Syntax
语法

SELECT column_name(s) INTO newtable [IN externaldatabase] FROM source

Make a Backup Copy
制作一个备份

The following example makes a backup copy of the "Persons" table:
下面的例子中会为"Persons"表制作一个备份

SELECT * INTO Persons_backupFROM Persons

The IN clause can be used to copy tables into another database:
IN子句可以用来将多个数据表拷贝到另一个数据库上：

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

If you only want to copy a few fields, you can do so by listing them after the SELECT statement:
如果你仅仅想拷贝其中的一部分，可以在SELECT后面列举出它们：

SELECT LastName,FirstName INTO Persons_backupFROM Persons

You can also add a WHERE clause. The following example creates a "Persons_backup" table with two columns (FirstName and LastName) by extracting the persons who lives in "Sandnes" from the "Persons" table:
你还可以加上WHERE子句。在下面的举例中会建立一个"Persons_backup"表，里面包含了在"Persons"表中住在"Sandnes"的个人姓(LastName)与名(FirstName)信息。

SELECT LastName,Firstname INTO Persons_backupFROM PersonsWHERE City='Sandnes'

Selecting data from more than one table is also possible. The following example creates a new table "Empl_Ord_backup" that contains data from the two tables Employees and Orders:
选择多个表进行备份也是可以的。下面的举例就建立了一个新的表"Empl_Ord_backup"里面的数据就有Employees和Orders这两张表的内容：

SELECT Employees.Name,Orders.ProductINTO Empl_Ord_backupFROM EmployeesINNER JOIN OrdersON Employees.Employee_ID=Orders.Employee_ID

最新相关文章

• ·实例讲解数据库备份过程中的常见问题
• ·SQL Select Into语句
• ·SELECT INTO
• ·insert into tablename与Select * into tablename
• ·select into 和 insert into select 两种表复制语
• ·高手指招 数据库中表行变列的方法
• ·LINQ to SQL 基本数据操作
• ·教你快速掌握一些异常精妙的SQL语句
• ·一些工作和学习中经常用到的SQL语句
• ·什么是数据结构、逻辑结构和物理结构？
• ·深入讲解数据库的具体分类及其相关概念
• ·深入讲解事务对象的基本内容及使用方法
• ·用一个实例讲解GROUP BY CEIL的使用方法
• ·讲解有关“SELECT FOR UPDATE“的一些概念
• ·“Select“语句究竟是如何来使用索引的？
• ·带你深入了解有关数据库的“并发问题”