1 from 2 where 3 group by 4 having 5select 6distinct 7 order by 8 limit
sum 求和 avg平均值 max最大 min最小 in not in count次数 group_coucat 分组后显示所有内
between 100 and 200 相当于 大于等于100 小于等于 200
like'xxx%' 以xxx开头 %是通配符 like'xxx$' 以XXX结尾 like'^以xxx开头'
1 from 2 where 3 group by 4 having 5select 6distinct 7 order by 8 limit
sum 求和 avg平均值 max最大 min最小 in not in count次数 group_coucat 分组后显示所有内
between 100 and 200 相当于 大于等于100 小于等于 200
like'xxx%' 以xxx开头 %是通配符 like'xxx$' 以XXX结尾 like'^以xxx开头'