MySQL笔记之基本查询的应用分析
2022-11-12 09:30:00
内容摘要
这篇文章主要为大家详细介绍了MySQL笔记之基本查询的应用分析,具有一定的参考价值,可以用来参考一下。
对此感兴趣的朋友,看看idc笔记做的技术笔记!
参考表:student
多字段查询
文章正文
这篇文章主要为大家详细介绍了MySQL笔记之基本查询的应用分析,具有一定的参考价值,可以用来参考一下。
对此感兴趣的朋友,看看idc笔记做的技术笔记!
参考表:student
多字段查询
代码如下:
1 2 | <code>mysql> select id,name,birth from student; </code> |
代码如下:
1 2 | <code>mysql> select * from student; </code> |
代码如下:
1 2 3 4 | <code>mysql> select * from student where id=901; mysql> select * from student where id>=904; mysql> select name from student where department= '计算机系' ; </code> |
代码如下:
1 2 3 | <code>mysql> select * from student where birth in(1988,1990); mysql> select * from student where id in(903,906); </code> |
代码如下:
1 2 | <code>mysql> select * from student where birth not in(1990,1998); </code> |
代码如下:
1 2 | <code>mysql> select * from student where birth between 1986 and 1988; </code> |
代码如下:
1 2 | <code>mysql> select * from student where id not between 904 and 906; </code> |
代码如下:
1 2 3 4 | <code>mysql> select * from student where name like '_三' ; mysql> select * from student where name like '张三' ; mysql> select * from student where name like '张%' ; </code> |
代码如下:
1 2 | <code>mysql> select * from student where name not like '张%' ; </code> |
代码如下:
1 2 | <code>mysql> select * from student where address is null; </code> |
代码如下:
1 2 3 | <code>mysql> select * from student where name like '张%' and birth>1985; mysql> select * from student where name like '张%' and birth>1985 and id like '%3' ; </code> |
代码如下:
1 2 3 | <code>mysql> select * from student where id=905 or birth=1988; mysql> select * from student where id=905 or birth=1988 or sex= '女' ; </code> |
distinct查询结果不重复
代码如下:
1 2 3 | <code>mysql> select distinct sex from student; mysql> select distinct department from student; </code> |
代码如下:
1 2 3 4 | <code>mysql> select * from student order by birth; mysql> select * from student order by birth asc; mysql> select * from student order by birth desc; </code> |
代码如下:
1 2 3 | <code>mysql> select sex,group_concat(name) from student group by sex; mysql> select sex, count (name) from student group by sex; </code> |
代码如下:
1 2 | <code>mysql> select * from student where birth regexp '1988|1990' ; </code> |
代码如下:
1 2 3 | <code>mysql> select * from student limit 2; mysql> select * from student limit 1,3; </code> |
注:关于MySQL笔记之基本查询的应用分析的内容就先介绍到这里,更多相关文章的可以留意
代码注释