MySQL学习笔记7:基本查询
来源:互联网 发布:mac在页面之间轻扫 编辑:程序博客网 时间:2024/06/06 01:56
参考表:student
多字段查询
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 birth>1985;mysql> select * from student where name like '张%' and birth>1985 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;
<script type="text/javascript"><!--google_ad_client = "ca-pub-1944176156128447";/* cnblogs 首页横幅 */google_ad_slot = "5419468456";google_ad_width = 728;google_ad_height = 90;//--></script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
- MySQL学习笔记7:基本查询
- MySQL学习笔记7:基本查询
- 5.笔记 MySQL学习——mysql基本显示查询
- 《MySQL学习笔记》:查询
- Hibernate基本查询(学习笔记)
- MySQL学习笔记7(查询数据)
- MySQL笔记 插入,查询,基本语句
- mysql查询优化学习笔记
- MYSQL学习笔记----子查询
- MySql基本语法(学习笔记)
- MySql基本语法(学习笔记)
- 【mysql基本命令】学习笔记
- MYSQL学习笔记-基本操作
- MYSQL学习笔记-mysql分区基本操作
- LINQ学习笔记三-----基本查询操作
- oracle学习笔记之基本查询
- Mysql查询高速缓存(学习笔记)
- PHP学习笔记——MySql 查询
- 数据库关闭、启动问题
- MySQL学习笔记10:修改数据
- 有向图的强连通分支以及最小点基
- MySQL学习笔记9:连接查询
- java.lang.IllegalStateException: Target host must not be null, or set in parameters.
- MySQL学习笔记7:基本查询
- WinPCap
- 无向图的连通分支
- 两个init方法的区别
- android 异常
- MySQL学习笔记6:索引
- JAVA过滤器和拦截器的区别(个人理解)
- Java 根据url下载图片 并 保存到对应的本地的新建文件夹中
- Jetty 介绍