MySQL学习笔记7：基本查询_MySQL-Mysql Tutorial-php.cn

Table of Contents

多字段查询

所有字段查询

where指定查询

in指定集合查询

not in非范围查询

between and指定范围查询

not between and不在指定范围的查询

like字符串匹配查询

not like不匹配查询

空值查询

and多条件查询

or多条件查询

distinct查询结果不重复

order by查询结果排序

group by分组查询

limit限制查询结果数量

Home

Database

Mysql Tutorial

MySQL学习笔记7：基本查询_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 01, 2016 pm 01:37 PM

mysql

bitsCN.com

参考表：student

多字段查询

mysql> select id,name,birth from student;

Copy after login

所有字段查询

mysql> select * from student;

Copy after login

where指定查询

mysql> select * from student where id=901;mysql> select * from student where id>=904;mysql> select name from student where department='计算机系';

Copy after login

in指定集合查询

mysql> select * from student where birth in(1988,1990);mysql> select * from student where id in(903,906);

Copy after login

not in非范围查询

mysql> select * from student where birth not in(1990,1998);

Copy after login

between and指定范围查询

mysql> select * from student where birth between 1986 and 1988;

Copy after login

not between and不在指定范围的查询

mysql> select * from student where id not between 904 and 906;

Copy after login

like字符串匹配查询

mysql> select * from student where name like '_三';mysql> select * from student where name like '张三';mysql> select * from student where name like '张%';

Copy after login

not like不匹配查询

mysql> select * from student where name not like '张%';

Copy after login

空值查询

mysql> select * from student where address is null;

Copy after login

and多条件查询

mysql> select * from student where name like '张%' and birth>1985;mysql> select * from student where name like '张%' and birth>1985 and id like '%3';

Copy after login

or多条件查询

mysql> select * from student where id=905 or birth=1988;mysql> select * from student where id=905 or birth=1988 or sex='女';

Copy after login

distinct查询结果不重复

mysql> select distinct sex from student;mysql> select distinct department from student;

Copy after login

order by查询结果排序

mysql> select * from student order by birth;mysql> select * from student order by birth asc;mysql> select * from student order by birth desc;

Copy after login

group by分组查询

mysql> select sex,group_concat(name) from student group by sex;mysql> select sex,count(name) from student group by sex;

Copy after login

limit限制查询结果数量

mysql> select * from student limit 2;mysql> select * from student limit 1,3;

Copy after login

bitsCN.com

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn