Question

mysql怎么把多张数据结构相同的表,合成一张视图表

mesh 表 结构为 id meshcg name price address brand datetime
tools 表 结构为 id toolscg name price address brand datetime
想合成的视图表为 iae 表结构为 cg name price address brand datetime
该怎么写

Answer 1

create view iae
as
select `meshcg` as `cg`,`name`,`price`,`address`,`brand`,`datetime` from `mesh`
union
select `toolscg` as `cg`,`name`,`price`,`address`,`brand`,`datetime` from `tools`

Answer 2

create view iae
as
select `meshcg` as `cg`,`name`,`price`,`address`,`brand`,`datetime` from `mesh`
union
select `toolscg` as `cg`,`name`,`price`,`address`,`brand`,`datetime` from `tools`

Answer 3

create view 视图名

as
select f1,f2,f3,f4 from table1
union
select f1,f2,f3,f4 from table2