MySQL基础小测试（五）

根据 sh_goods_attr商品属性与 sh_goods_attr_value商品属性值表：

查询id为6的分类所具有的属性信息,将属性按照层级并排显示。 查询id为5的商品的所有属性信息,将属性名称和属性值并排显示。 查询id为1的属性的所有子属性值。 查询拥有属性值个数大于1的商品id和名称。

Select a.sort sort1,a.name name1,b.sort sort2,b.name name2 From sh_goods_attr a Join sh_goods_attr b On a.id=b.parent_id
Where a.category_id=6 Order By a.sort Asc,b.sort Asc;

Select b.name,a.attr_value From sh_goods_attr_value a Join sh_goods_attr b On a.attr_id=b.id 
Where a.goods_id=5;
Select c.sort sort1,c.name name1,b.sort sort2,b.name name2,attr_value From sh_goods_attr_value a Join sh_goods_attr b On a.attr_id=b.id
Join sh_goods_attr c On b.parent_id=c.id Where a.goods_id=5 Order By c.sort ASC,b.sort ASC;

Select attr_value From sh_goods_attr_value Where attr_id In (Select id From sh_goods_attr Where parent_id=1);

Select id,name From sh_goods Where id In (Select goods_id From sh_goods_attr_value Group By goods_id Having Count(id)>1);