select into from 和 insert into select 的用法和区别
来源:互联网 发布:淘宝店铺街入口 编辑:程序博客网 时间:2024/05/21 07:59
select into from 和 insert into select都是用来复制表,两者的主要区别为: select into from 要求目标表不存在,因为在插入时会自动创建。insert into select from 要求目标表存在
备份表数据: create table emp as select * from scott.emp
还原表数据:insert into emp select * from scott.emp
1. 复制表结构及其数据:
create table table_name_new as select * from table_name_old
2. 只复制表结构:
create table table_name_new as select * from table_name_old where 1=2;
或者:
create table table_name_new like table_name_old
3. 只复制表数据:
如果两个表结构一样:
insert into table_name_new select * from table_name_old
如果两个表结构不一样:
insert into table_name_new(column1,column2...) select column1,column2... from table_name_old
pastinghttp://www.studyofnet.com/news/182.html
0 0
- insert into select 和 select into from 用法和区别
- select into from 和 insert into from 的区别
- insert into from和select from into的区别
- SELECT INTO FROM 和 INSERT INTO SELECT 的用法和区别
- select into from 和 insert into select 的用法和区别
- select into from 和 insert into select 的用法和区别
- select into from 和 insert into select 的用法和区别
- insert into select 和select into from的用法和区别
- select into from 和 insert into select 的用法和区别
- select into from 和 insert into select 的用法和区别复制表数据
- select into from 和 insert into select 的用法和区别
- select into from 和 insert into select 的用法和区别
- select into from 和 insert into select 的用法和区别
- select into from 和 insert into select 的用法和区别
- select into from 和 insert into select 的用法和区别
- 【转】select into from 和 insert into select 的用法和区别
- select into from 和 insert into select 的用法和区别
- select into from 和 insert into select 的用法和区别
- HDU5772 String problem
- mongodb导出数据库到文本文件
- Maven实战(九)——打包的技巧
- Spring AOP自定义Annotation搭配log4j做日志
- JAVA中参数传递的迷惑点
- select into from 和 insert into select 的用法和区别
- Spring Data JPA书写原生态sql拼接
- bzoj1877(费用流)
- Shell编程---基础
- Android——从本地图库上传图片至服务器
- centos配置epel和remi源
- 湖南省第八届省赛 病毒 (最长公共上升子序列)
- 三:Windows API的功能分类
- PHP获取当前页面的名称,主机名,URL完整地址,URL参数,获取IP