多字段查询复制代码 代码如下:mysql
select id,name,birth from student;富有字段查询复制代码 代码如下:mysql select * from
student;where钦赐询问复制代码
代码如下:mysql select * from student where id=901;mysql select * from
student where id=904;mysql select name from student where
department=’计算机系’;in钦定会集查询复制代码 代码如下:mysql select * from student
where birth in(1988,1990);mysql select * from student where id
in(903,906);not in非节制查询复制代码
代码如下:mysql select * from student where birth not
in(1990,1998);between and钦赐范围查询复制代码 代码如下:mysql select * from student
where birth between 1986 and 1988;not between
and不在钦点范围的询问
复制代码
代码如下:mysql select * from student where id not between 904 and
906;like字符串相配查询复制代码
代码如下:mysql select * from student where name like ‘_三’;mysql
select * from student where name like ‘张三’;mysql select * from
student where name like ‘张%’;not like不相配查询复制代码 代码如下:mysql select * from student
where name not like ‘张%’;null查询复制代码 代码如下:mysql select * from student
where address is null;and多规格查询复制代码 代码如下:mysql select * from student
where name like ‘张%’ and birth1985;mysql select * from student where
name like ‘张%’ and birth1985 and id like ‘%3’;or多规格查询复制代码 代码如下:mysql select * from student
where id=905 or birth=1988;mysql select * from student where id=905 or
birth=1988 or sex=’女’;

distinct查询结果不另行复制代码
代码如下:mysql select distinct sex from student;mysql select distinct
department from student;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;group by分组查询复制代码 代码如下:mysql select
sex,group_concat(name) from student group by sex;mysql select
sex,count(name) from student group by sex;正则表明式查询复制代码 代码如下:mysql select * from student
where birth regexp ‘1988|1990’;limit约束查询结果数量复制代码 代码如下:mysql select * from student
limit 2;mysql select * from student limit 1,3;

参考表:student