# 视图
# 创建一个视图，存储复杂的数据表，其本质是引用不同数据表中的数据，视图没有实体的存储
create view v_goods_info as
select g1.*,g2.name as cate_name,g3.name as brand_name
from goods as g1
left join goods_cates as g2 on g1.cate_id=g2.id
left join goods_brand as g3 on g1.brand_id=g3.id;
# 查询视图
show tables;
from * from v_goods_info;
