mysql、oracle复制表结构和数据

oracle

复制表结构和数据
create table A as select * from B  //as不能省
复制表结构
create table A as select * from B where 1=2

复制表数据
insert into A select * from B  //全部列
insert into A(id,name)  select id,name from B  //部分

mysql

复制表结构和数据
create table A like B   //有主键
create table A [as] select * from B   //as可省略

复制表结构
create table A select * from B where 1=2

复制数据
insert into A  select * from B  //全部列
insert into A (id,name) select id,name from B  //部分