IN(20,21,22,23) 表示在这个范围内
LIKE '_ _ _' ; 表示三个字符
MYSQL 聚合函数:
SELECT 聚合函数(字段列表)FROM 表名;
select count (*) from emp;
count 统计数量
select avg(age) from emp;
max
min
select sum(age) from emp where workaddress='西安';
所有NULL不计算
分组查询 GROUP BY:
SELECT workaddress,COUNT(*) address_count FROM emp WHERE age<45 GROUP BY gender HAVING address_count>3 ;
HAVING 后面是分组过滤后的条件
执行顺序:WHERE > 聚合函数 > HAVING
排序查询 ORDER BY:
ASC 升序 默认值
DESC 降序
SELECT *FROM emp ORDER BY age ASC;
ORDER BY age ASC, enrty ASC;
分页查询 LIMIT 起始索引,每页 展示记录数:
起始索引=(查询页码-1)*每页显示记录数