1、复制lianxi2表结构,创建新表news(注:可以有多种方式)
create table news1 like lianxi2
create table news2 as select *from lianxi2 where 2=1
show tables
2、复制lianxi3表结构和数据,创建新表newtable
create table newstable as select *from lianxi3
show tables
3、复制lianxi3表结构的id,stu_id,istester三个字段 ,创建新表newstable2
create table newstable2 as select id,stu_id,istester from lianxi3 where 2=1
show tables