Python第十二天

1.递归的条件
自己调用自己
有明确的终止条件

2.mysql
查询名字中有小的名字
select name from students where name like “%小%”

3.查询有两个字的名字
select name from students where name like “__”
(两个下划线)

4.查询至少有两个字的名字
select name from students where like"%__"

rlike 正则
5.查询以周开始，以伦结尾的名字
select name from students where rlike “^*\周\伦&”

6.排序：
order by 字段
asc 从小到大排序，即升序
desc 从大到小排序，即降序

7.聚合函数
作用：总数，count，查询男性有多少人
select count（*）from students where gender=1

8.最大值
select max（age）from students；

9.求和
select sum（age）from students

10.平均值
select avg（age）from students

四舍五入round（123.43，）保留一位小数
select round(sum(age)/count(*）,2) from students;

–计算男性的平均身高，保留2位小数

11.分组：
group by
按照性别分组，查询所有的性别
select gender,group_concat(name),avg(age) from students group by gender having avg(age)

select gender,group_contact(name),avg(age) from students group by gender;

select gender,group_concat(name)from students group by gender having count(*)>2;

12.分页功能数据库：
限制查询出来的数目：
select * from students limit 5；
select * from students limit 0,2;
select * from students limit 2,2;
select * from students limit 4,2;
select * from students limit 6,2;

select * from students order by age asc limit 10,2

13.连接查询
inner join … on
查询有能够对应班级的学生以及班级信息
select * from students inner join classes on students. cls_id=classes.id

查询有能够对应班级的学生以及班级信息，显示学生的所有信息，只显示班级名称
select s.*,c.name from students as s inner join classes as c on s.cls_id=c.id