由旧表创建新表:create table as select*****;
合并表:select a.*,b.colm1,colm2 from table1 a inner join table2 b on a.name=b.name;
相同字段合并:(可重复)select * from table1 union all select * from table2; (去重复)select * from table1 union select * from table2;
由旧表创建新表:create table as select*****;
合并表:select a.*,b.colm1,colm2 from table1 a inner join table2 b on a.name=b.name;
相同字段合并:(可重复)select * from table1 union all select * from table2; (去重复)select * from table1 union select * from table2;