1 创建数据库
create database day01;
2 创建表
create table t_student(
id int(3) PRIMARY KEY auto_increment,
name varchar(3),
age int (3),
score int(3),
classroom varchar(10)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
3 添加数据
insert into t_student(name,age,score,classroom) values(‘张三’,15,80,‘2班’);
insert into t_student(name,age,score,classroom) values(‘李四’,16,80,‘2班’);
insert into t_student(name,age,score,classroom) values(‘王五’,19,90,‘1班’);
insert into t_student(name,age,score,classroom) values(‘赵六’,18,90,‘1班’);
insert into t_student(name,age,score,classroom) values(‘田七’,19,85,‘2班’);
4 删除一条数据
delete from t_student where name=‘田七’;
5 修改一条数据
update t_student set age=20 where name=‘张三’;
6 排序
select * from t_student order by score desc;
7 聚合函数
select sum(score) ‘总成绩’, avg(score) ‘平均分’ from t_student;