MySQL学习笔记7:基本查询
来源:互联网 发布:怎么申请淘宝介入退款 编辑:程序博客网 时间:2024/06/14 04:15
MySQL学习笔记7:基本查询
参考表: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;
- 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 查询
- Apache Hadoop YARN – ResourceManager
- Mysql新建用户和数据库授权
- safari翻译插件
- iOS9 This application is modifying the autolayout engine from a background thread, which
- iOS中常用的四种数据持久化方法简介
- MySQL学习笔记7:基本查询
- oracle索引介绍之位图(bitmap)索引
- android-自定义View初步探索
- 关于android第三方包混淆的经验总结
- ifconfig,iwconfig,wpa_ctl的使用
- 为什么要用内部类
- Linux下的编码和字符集的资料
- 字符串NSString和数组NSArray操作
- mapjoin测试