mysql 查询

第四章

select * from student_user where age>20;

select * from student_user where age>20 and class=2;

select * from student_user where birthday>'2003-03-04';

select * from student_user where age between 16 and 22;

select * from student_user where age in (16,20);

select * from student_user where name like '%豹';

select * from student_user where name like '%丁%';

select * from student_user where name like '芝士%';

select * from student_user where name like '%零';

select * from student_user where name like '_璨';

select * from student_user where name like '超';

select * from student_user where name like '芝___';

select*from student_user where name like '__丁%';

select * from student_user order by age; select * from student_user order by age asc; select * from student_user order by age desc;

select count(*) from student_user; select count(1) from student_user;

select id,name,max(age) from student_user; select id,name,min(age) from student_user;

select sum(age) from student_user; select avg(age) from student_user;

select class,count(1) as '学生人数' from student_user group by class; select class,avg(price) as '平均分' from student_user group by class;

select class,avg(price) as 'avg_price' from student_user group by class having avg_price =38; having 对分组后的数据，再次做筛选

条件筛选顺序 select--from--where--group by--having--order by

limit 分页查询

select * from student_user limit m,n;

m表示：大于n，从n+1开始

n表示：偏移量，查几条

selectfrom student_user limit 0,9;

selectfrom student_user limit 3,3;