MySQL(6)

create database sql_tutorial;
use sql_tutorial;
create table `student`(
  `student_id` int auto_increment,
  `name` varchar(20),
  `major` varchar(20) ,
  `score` int,
  primary key(`student_id`)
);
insert into `student` values(1,'小白','英语',50);
insert into `student` values(2,'小黑','历史',80);
insert into `student` values(3,'小红','语文',90);
insert into `student` values(4,'小绿','物理',75);
insert into `student` values(5,'小新','地理',95);
#########################从这里开始#####################
#查询语句
select * from `student`;
select `name` from `student`;
select `name`,`major` from `student`;
#查询语句与排序语句的混用
#升序ascending
select * from `student`
order by `score`;
#降序descending
select * from `student`
order by `score` desc;
#order语句可以多指标多重排序
select * from `student`
order by `score`,`student_id`;
#查询语句与limit语句、排序语句混用
select *from `student`
limit 2;
select * from `student`
order by `score`
limit 2;
#与where语句混用
select *from `student`
where `major`='英语';
select * from `student`
where `major`='英语' or `score` <> 80;
select *from `student`
where `major` in('历史','生物','物理');#or语句的简写

语法内容总结：

1：查询语句select

2：查询语句select和order/limit/where混用（查询语句与条件语句进行混用达到的效果是什么）

3：order语句的多重排序

4：where语句的简写