数据库名称可以为【schooldb】,字符集【utf8】,排序规则【utf8_general_ci】
建表语句
CREATE TABLE `student` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
`createName` datetime DEFAULT NULL,
`userName` varchar(20) DEFAULT NULL,
`pwd` varchar(36) DEFAULT NULL,
`phone` varchar(11) DEFAULT NULL,
`age` tinyint(3) DEFAULT NULL,
`sex` char(2) DEFAULT NULL,
`introduce` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
插入语句
insert into student values
(0,'2024-02-25 10:00:00','伯','123','18912345678',16,'女','hhh');
insert into student values
(0,'2024-02-25 10:00:00','仲','123','18912345678',18,'男','hhh');
insert into student values
(0,'2024-02-25 10:00:00','叔','123','18912345678',15,'男','hhh');
insert into student values
(0,'2024-02-25 10:00:00','季','123','18912345678',17,'女','hhh');
insert into student values
(0,'2024-02-25 10:00:00','伯子','123','18912345678',21,'男','hhh');
insert into student values
(0,'2024-02-25 10:00:00','仲子','123','18912345678',15,'女','hhh');
insert into student values
(0,'2024-02-25 10:00:00','季子','123','18912345678',19,'男','hhh');
聚合函数的使用语句
#聚合函数5个,数量count(x),最大值max(x),最小值min(x),平均数avg(x),求和sun(x)。
select count(*) '所有成年人数量' from student where age>=18;
select max(age) '最大年龄',min(age) '最小年龄' from student;
select avg(age) '平均年龄' from student;
select sum(age) '总年龄' from student;
select avg(age) 'avg出的总年龄',sum(age)/(select count(*)from student)'计算机出的' from student;