SQL SELECT INTO 语句
来源:互联网 发布:关注网站源码 编辑:程序博客网 时间:2024/05/21 16:01
通过 SQL,您可以从一个表复制信息到另一个表。
SELECT INTO 语句从一个表复制数据,然后把数据插入到另一个新表中。
SQL SELECT INTO 语句
SELECT INTO 语句从一个表复制数据,然后把数据插入到另一个新表中。
SQL SELECT INTO 语法
我们可以复制所有的列插入到新表中:
SELECT *
INTO newtable [IN externaldb]
FROM table1;
INTO newtable [IN externaldb]
FROM table1;
或者只复制希望的列插入到新表中:
SELECT column_name(s)
INTO newtable [IN externaldb]
FROM table1;
INTO newtable [IN externaldb]
FROM table1;
提示:新表将会使用 SELECT 语句中定义的列名称和类型进行创建。您可以使用 AS 子句来应用新名称。
SQL SELECT INTO 实例
创建 Customers 的备份复件:
SELECT *
INTO CustomersBackup2013
FROM Customers;
INTO CustomersBackup2013
FROM Customers;
请使用 IN 子句来复制表到另一个数据库中:
SELECT *
INTO CustomersBackup2013 IN 'Backup.mdb'
FROM Customers;
INTO CustomersBackup2013 IN 'Backup.mdb'
FROM Customers;
只复制一些列插入到新表中:
SELECT CustomerName, ContactName
INTO CustomersBackup2013
FROM Customers;
INTO CustomersBackup2013
FROM Customers;
只复制德国的客户插入到新表中:
SELECT *
INTO CustomersBackup2013
FROM Customers
WHERE Country='Germany';
INTO CustomersBackup2013
FROM Customers
WHERE Country='Germany';
复制多个表中的数据插入到新表中:
SELECT Customers.CustomerName, Orders.OrderID
INTO CustomersOrderBackup2013
FROM Customers
LEFT JOIN Orders
ON Customers.CustomerID=Orders.CustomerID;
INTO CustomersOrderBackup2013
FROM Customers
LEFT JOIN Orders
ON Customers.CustomerID=Orders.CustomerID;
提示:SELECT INTO 语句可用于通过另一种模式创建一个新的空表。只需要添加促使查询没有数据返回的 WHERE 子句即可:
SELECT *
INTO newtable
FROM table1
WHERE 1=0;
INTO newtable
FROM table1
WHERE 1=0;
0 0
- SQL SELECT INTO 语句
- SQL SELECT INTO 语句
- SQL Select Into语句
- SQL SELECT INTO 语句
- SQL SELECT INTO 语句
- SQL SELECT INTO 语句
- SQL SELECT INTO 语句
- SQL SELECT INTO 语句
- SQL SELECT INTO 语句
- SQL SELECT INTO 语句
- SQL SELECT INTO 语句
- SQL语句SELECT INTO
- SQL SELECT INTO 语句
- insert into ...... select ....sql语句
- [SQL]SELECT INTO 和 INSERT INTO SELECT 两种表复制语句
- SQL中SELECT INTO和INSERT INTO SELECT语句介绍
- SQL中SELECT INTO和INSERT INTO SELECT语句介绍
- sql 语句:SELECT INTO 和 INSERT INTO SELECT 表复制
- 深入理解Linux网络技术内幕-设备注册和初始化(四)
- Andoird无法调用微信支付原因
- 抽象类管理fragment
- Genymotion Eclipse插件安装
- Failed to load the JNI shared Library (JDK)
- SQL SELECT INTO 语句
- Struts2自定义拦截器实例—登陆权限验证(两种方式的拦截)
- SQL UNION 和 UNION ALL 操作符
- Halcon-基于HALCON的模板匹配方法总结
- [leetcode] 322. Coin Change
- LoadRunner第一节【认识LoadRunner测试app原理】
- runtime那些事(消息机制)
- Phone number - Multiway Trees
- 打开多个页面,怎么用获取哪个页面正在活动中 ?