Create table as select
来源:互联网 发布:mac mini 更新 编辑:程序博客网 时间:2024/06/10 12:01
今天看书的时候,看到一句
create table emp_tran
2 as select * from emp;
最后select了下,结果为:
SQL> SELECT empno,ename,job,sal
2 FROM emp_tran
3 WHERE job='CLERK';
EMPNO ENAME JOB SAL
---------- ---------- --------- ----------
7369 SMITH CLERK 800
7876 ADAMS CLERK 1100
7900 JAMES CLERK 950
7934 MILLER CLERK 1300
最后挺惊讶,百度了一下,原来create table a as select * from b可以创建一个与b表结构一样的表
create table a
as select * from b
可以创建一个与B一模一样的表!
0 0
- Create table as select
- create table as select
- oracle create table as select
- Oracle Create Table as Select
- 浅谈create table as select
- postgres create table as select & create table like
- MySql create table ... as select * from ..
- Select into from 与 Create Table As
- create table as select性能测试
- sqlserver不能直接create table as select ......
- sqlserver不能直接create table as select ......
- create table as select性能测试
- create table as select性能测试
- sqlserver不能直接create table as select ......
- create table as select 和 create table 再insert into select 的差异
- 关于"CREATE TABLE AS SELECT"不支持"ORDER BY"
- Using CREATE TABLE AS SELECT (CTAS) to Reorganize Oracle Tables
- Oracle中,使 CREATE TABLE AS SELECT 支持ORDER BY
- Android入门之Handle
- iOS开发中的SQLite知识总结
- 1200人民币,黑莓发布新机“雅加达”
- Java源码初窥--String
- POJ 3414 Pots
- Create table as select
- Xcode开发调试技巧
- HDU 1176 免费馅饼 (简单DP)
- hdu 3535 AreYouBusy
- 23种设计模式(3):抽象工厂模式
- 转发跟重定向的区别【个人理解】
- Error in an XML file: aborting build.
- 从零开始学习OpenGL ES之四 – 光效
- SSh结合Easyui实现Datagrid的分页显示