MySQL的数据查询

目录

条件查询

多表联查join

嵌套查询

自连接查询

---

条件查询

1. distinct 去重

   • 除去所查询的所有查询字段都一样的数据

   select distinct name, age from student;

2. where 按条件查询

   select name from student where id=1

3. like 模糊查询

   select name from student where name like "张%"   //张开头的
   select name from student where name like "%张"   //张结尾的
   select name from student where name like "%张%"  //含有张的，开头结尾也算
   select name from student where name like "张__"
       //张开头，后面两个字符的。

4. limit 指定位置查询

   select name from student limit 2;   //显示前两条
   select name from student limit 0, 2;    //从第一条开始，查询两条
   select name from student limit 3,2; //从第四条开始，查询两条

5. order by 排序

   select name, money from student order by money asc;  //默认升序
   select name, money from student order by money desc; //降序

6. between and 介于

   select name, money from student where money between 10 and 1000;
   select name, money from student where money
   >=10 and money<=1000;

7. null 数据是否为空

   select name from student where money is null;   //money字段为空的
   select name from student where money is not null;   //money字段不为空的

多表联查join

在使用多表联查的开始，我们记录一下各种关键字的