mysql常用函数

COUNT()：统计记录的数目
SUM()：求字段的和
AVG()：求字段的平均值
MAX()：求字段的最大值
MIN()：求字段的最小值

Group by 分组
order BY 排序 （desc）倒叙
if test mybatis中sql语句的判断用法

select s.goods_id, s.goods_name, s.photo, sum(s.number) as number, s.unit, s.price, s.total_pricve, s.category, s.create_by, s.location, s.sale, s.booking,s.user_id, s.bar_code, s.serial,s.inventory_id, s.attribute, s.create_time, i.wh_name as inventoryName, u.user_name as userName from sys_goods s left join sys_warehouse_inventory i on s.inventory_id = i.id left join sys_user u on s.user_id = u.user_id sql语句的简写