多表查询-排序-分组-聚合函数

– select * from cate;
– select * from goods;
– select * from brand;

– -- #1，查询商品以及商品对应的品牌名
select goods.name,brand.brandename
from goods
inner join brand
where goods.brande_id=brand.id

– #查询商品价格大于9.9的商品以及对应的商品名
select g.name,b.brandename
from goods as g,brand as b
where g.price>9.9 and g.brande_id=b.id;

– #查询每个品牌的商品的个数并且展示品牌的名字
select count(*),b.brandename
from goods as g,brand as b
where g.brande_id=b.id
group by g.brande_id;

– 99语法规则
‘’’
select 查询字段
from 表名1 join 表名2
on 连接条件
where 筛选条件
group by 字段名
order by 字段名 asc|desc
‘’’
一、WHERE条件筛选
SELECT * FROM goods
SELECT goods.name,goods.price FROM goods;
SELECT goods.name AS ‘商品名’,goods.price AS ‘价格’ FROM goods;
SELECT goods.name ‘商品名’,goods.price ‘价格’ FROM goods;

SELECT DISTINCT goods.name AS ‘商品名’ FROM goods

找出所有单价大于9.9的商品

SELECT goods.name FROM goods WHERE goods.price >9.9

找出价格小于9.9 ，已经上架的产品

SELECT goods.name FROM goods WHERE goods.price <9.9 AND goods.is_show =1

找出商品名中带火的商品

SELECT goods.name FROM good