[b]参考表：student[/b]
[img]http://files.jb51.net/file_images/article/201305/2013050317411276.png[/img]
[b]多字段查询
[/b]
mysql> select id,name,birth from student;
[b]所有字段查询
[/b]
mysql> select * from student;
[b]where指定查询
[/b]
mysql> select * from student where id=901;
mysql> select * from student where id>=904;
mysql> select name from student where department='计算机系';
[b]in指定集合查询
[/b]
mysql> select * from student where birth in(1988,1990);
mysql> select * from student where id in(903,906);
[b]not in非范围查询
[/b]
mysql> select * from student where birth not in(1990,1998);
[b]between and指定范围查询
[/b]
mysql> select * from student where birth between 1986 and 1988;
[b]not between and不在指定范围的查询
[/b]
mysql> select * from student where id not between 904 and 906;
[b]like字符串匹配查询
[/b]
mysql> select * from student where name like '_三';
mysql> select * from student where name like '张三';
mysql> select * from student where name like '张%';
[b]not like不匹配查询
[/b]
mysql> select * from student where name not like '张%';
[b]null查询
[/b]
mysql> select * from student where address is null;
[b]and多条件查询
[/b]
mysql> select * from student where name like '张%' and birth>1985;
mysql> select * from student where name like '张%' and birth>1985 and id like '%3';
[b]or多条件查询
[/b]
mysql> select * from student where id=905 or birth=1988;
mysql> select * from student where id=905 or birth=1988 or sex='女';
[b]distinct查询结果不重复
[/b]
mysql> select distinct sex from student;
mysql> select distinct department from student;
[b]order by查询结果排序
[/b]
mysql> select * from student order by birth;
mysql> select * from student order by birth asc;
mysql> select * from student order by birth desc;
[b]group by分组查询
[/b]
mysql> select sex,group_concat(name) from student group by sex;
mysql> select sex,count(name) from student group by sex;
[b]正则表达式查询
[/b]
mysql> select * from student where birth regexp '1988|1990';
[b]limit限制查询结果数量
[/b]
mysql> select * from student limit 2;
mysql> select * from student limit 1,3;
机械节能产品生产企业官网模板...
大气智能家居家具装修装饰类企业通用网站模板...
礼品公司网站模板
宽屏简约大气婚纱摄影影楼模板...
蓝白WAP手机综合医院类整站源码（独立后台）...
