mysql 视图

为了查询方便，不能用于增删改，只用于查询

 

下面的语句依goods为准，关联查询了其它两个表

select * from goods as g left join goods_brands as b on g.brand_id = b.id left join goods_cates as c on g.cate_id=c.id;

 

可以把上面关联查询出来的结果生成一个新的虚拟的表，也就是视图，命名为view_table：

create view view_table as select g.*,b.name as brand_name,c.name as cate_name from goods as g inner join goods_brands as b on g.brand_id = b.id inner join goods_cates as c on g.cate_id=c.id;

现在show tables会发现多出一张表：view_table，用select * from view_table; 会直接显示最开始关联查询的结果。

 

删除视图：

drop view view_table;