1.创建视图
在多表上创建视图:
#创建视图
Create View view_goods_cate As
Select g.id,g.name,c.name category_name
From sh_goods Left Join sh_goods_category c
On g.category_id=c.id;
#查询视图
Select * From view_goods_cate Limit 3;
自定义列名称:
#创建视图
Create View view_goods_promo
(sn,title,promotion_price) As
Select id,name,price*0.8