Mysql多视图合并:
create view 视图名
as
select * from 视图1 union all select * from 视图2 union all select * from 视图3 union all select * from 视图5
注意:以上视图的字段相同,生成新的视图字段与其匹配。
Mysql多视图合并:
create view 视图名
as
select * from 视图1 union all select * from 视图2 union all select * from 视图3 union all select * from 视图5
注意:以上视图的字段相同,生成新的视图字段与其匹配。