怎么把30个结构相同的表的数据 弄到一个表 或者 弄成视图 ，------解决思路----------------------
select col1, col2, col3, ...
from table1
union all
select col1, col2, col3, ...
from table2
union all
select col1, col2, col3, ...
from table3
...
------解决思路----------------------
create view v1
as
select col1, col2, col3, ...
from table1
union all
select col1, col2, col3, ...
from table2
union all
select col1, col2, col3, ...
from table3
...
------解决思路----------------------
写成视图比较好，原表就不要动了。