/**
1.建表.(建表指定列,并赋值指定列的数据)
*/
create table new_resource(
id ,
lastname ,
loginid
)
as
select id ,lastname ,loginid from hrmresource;
/**
2.建表.(复制表结构,不复制数据)
*/
create table new2_resource as select * from hrmresource where 1=2;
/**
3.建表.(赋值表结构，赋值所有数据)
*/
create table new3_resourece
as
select * from hrmresource
