1.第一步启动数据库
systenctl start mysqld
2 运行数据库
use 数据库名
1.查询所有数据
select * from score;
2.查询某一列的数据
select math from score;
3.查询多列数据
select name,math,english from score;
1.去重
select distinct math from score;
降序 desc;
select math from score order by math desc;
升序 asc;
select math from score order by math asc;
1.返回表前n行
select math from score limit n;
2.返回表特定行
select * from score limit n,m;