mysql where 高级用法_MySQL高级用法

-- 关联查询

-- select * from Goods_BomItems s,Goods_Bom t where t.GoodsBomId = s.GoodsBomId and t.GoodsBomCode='1042669'

-- 范围查询

-- select * from Goods_Bom where GoodsBomCode in ('','')

-- 模糊查询

-- select * from Goods_Bom where GoodsBomName like '%%'

-- 倒序排序

-- select * from Goods_Bom order by CreateTime DESC;

-- 分组查询

-- SELECT t.GoodsBomName, COUNT(*) from Goods_Bom t

-- group by GoodsBomName

-- 子查询

select * from Goods_BomItems

where (GoodsBomId) = {

SELECT * from Goods_Bom

where goo

}