一,使用MySQL
1,连接
mysql -u root -p 密码
2,选择数据库
SHOW DATABASES;
USE user;
3.获取 数据库students 中的表:
SHOW TABLES;
4.显示列表:
SHOW columns FROM students;
二,检索数据
1. select 语句
1.1. 检索单个列
select student_id from students;
1.2 检索多个列
select student_id,student_name,student_sex from students;
1.3 检索所有列
select*from students;
1.4 检索不同的行
select distinct student_age from students;
distinct关键字只返回不同的值
1.5 限制结果
select student_age from students limit 5;
limit 5:返回不多于5行
select student_age from students limit 3,5;
limit3,5:从3行5开始的5行
limit3,5=limit 5 offset 3
1.6 使用完全限定的表名
select students.student_age from user.students;
三、排序检索数据
order by
1.单列排序
select student_name from students order by student_name;
2.多列排序
select student_id ,student_name ,student_age from students order by student_id ,student_name ;
3.制定排序方向
DESC 降序 ASC升序(系统默认升序)
1)按照年纪降序排列
select student_id ,student_name ,student_age from students order by student_age DESC ,student_name ;
student_age 指定DESC ,student_name列未指定,仍然是标准升序排列
2)使用order by 和limit的组合
(找最大的年龄)
select student_age from students order by student_age desc limit 1;