mysql day3

#SELECT语句的使用 
SELECT name,(chinese+english+math) from student;
#在所有学生总分加10分的情况
SELECT name,(chinese+english+math+10) from student;
#使用别名表示学生分数。
SELECT name as '名字',(chinese+english+math) as toscore from student;
#查询总分大于200分的人
select * from student where (chinese+english+math)>200;
select math,chinese,english from student where math>60 and id>4;
SELECT * from student where name like'赵%' and (chinese+english+math)>200 and math<chinese;
SELECT * from student where english between 80 and 90;
select * from student where math=89 or math=90 or math=91;
SELECT * from student where name like '张%';
#演示 ORDER BY的使用 对数学成绩排序后输出
SELECT * FROM student ORDER BY math;
#按总分降序
SELECT *,(math+chinese+english) as sum_score FROM student ORDER BY (math+chinese+english) DESC;
#对姓李的同学进行升序
select * from student where name like '韩%' ORDER BY math;

INSERT into student VALUES(10,'韩星',100,100,100)