没什么好办法。只能用 insertcreate table 表2 as select * from 表1 where 字段1='a'; create table 表3 as select * from 表1 where 字段1='b'; create table 表4 as select * from 表1 where 字段1='c'; create table 表5 as select * from 表1 where 字段1='d';合并 create table 表1 as select * from ( select * from 表2 union all select * from 表3 union all select * from 表4 union all select * from 表5 ) t
create table 表3 as select * from 表1 where 字段1='b';
create table 表4 as select * from 表1 where 字段1='c';
create table 表5 as select * from 表1 where 字段1='d';合并
create table 表1 as select * from (
select * from 表2
union all
select * from 表3
union all
select * from 表4
union all
select * from 表5
) t