select语句用于查询检索表中的数据,是mysql中最基本的语句之一,select语句的通用形式如下:
select 你要的信息 from 数据表 where 满足的条件
比如:
select * from mytable where id=1; /*查询mytable表中id为1的数据行*/
下面向大家介绍mysql select的各种使用情况。
1.结合where语句来设定查询检索条件
select * from score where score>95;
select last_name,first_name from president where last_name=’Tom’;
select last_name,first_name,birth,state from president where birth
2.结合distinct关键字查询不重复记录
select distinct username from usertable; /*查询usertable表中所有不重复的username*/
3.结合order by和limit实现分页和排序
select * from mytable order by name; /*查询mytable表并按照name升序排序*/
select * from mytable order by name,id desc;/*按照name升序,id降序查询mytable表*/
select * from mytable order by name limit 1,3;/*按照name升序排序并只获取第二行到第四行数据*/
4.集合聚合函数(sum,count)实现统计查询
select count(*) from student where sex=’f’;/* http://www.manongjc.com/article/1412.html */
select count(*) from student where sex=’m;
select sex,count(*) f rom student group by sex;