mysql 左联结与右联结
2024-09-07 03:25:21
mysql> select * from test;
+----+------------+-------+-----------+
| id | name | score | subject |
+----+------------+-------+-----------+
| | xiaoming | | shuxue |
| | xiaohong | | shuxue |
| | xiaohong | | english |
| | xiaohong | | physics |
| | xiaohong | | astronaut |
| | xiaoming | | physics |
| | xiaoming | | astronaut |
| | xiaoming | | english |
| | xiaobai | | astronaut |
| | .2xiaobai | | english |
| | .2xiaobai | | physics |
| | 3xiaobai | | shuxue |
| | 123xiaohei | | astronaut |
| | xiaohei | | shuxue |
| | xiaohei | | physics |
| | .12xiaohei | | english |
+----+------------+-------+-----------+
rows in set (0.00 sec) mysql> select * from user;
+------+----------+-----------+
| id | name | address |
+------+----------+-----------+
| | xiaoming | beijing |
| | xiaobai | shandong |
| | xiaohong | suzhou |
| | xiaohei | changchun |
+------+----------+-----------+
rows in set (0.00 sec) mysql> select * from user left join test on user.name=test.name;
+------+----------+-----------+------+----------+-------+-----------+
| id | name | address | id | name | score | subject |
+------+----------+-----------+------+----------+-------+-----------+
| | xiaoming | beijing | | xiaoming | | shuxue |
| | xiaohong | suzhou | | xiaohong | | shuxue |
| | xiaohong | suzhou | | xiaohong | | english |
| | xiaohong | suzhou | | xiaohong | | physics |
| | xiaohong | suzhou | | xiaohong | | astronaut |
| | xiaoming | beijing | | xiaoming | | physics |
| | xiaoming | beijing | | xiaoming | | astronaut |
| | xiaoming | beijing | | xiaoming | | english |
| | xiaobai | shandong | | xiaobai | | astronaut |
| | xiaohei | changchun | | xiaohei | | shuxue |
| | xiaohei | changchun | | xiaohei | | physics |
+------+----------+-----------+------+----------+-------+-----------+
rows in set (0.00 sec) mysql> select * from user right join test on user.name=test.name;
+------+----------+-----------+----+------------+-------+-----------+
| id | name | address | id | name | score | subject |
+------+----------+-----------+----+------------+-------+-----------+
| | xiaoming | beijing | | xiaoming | | shuxue |
| | xiaoming | beijing | | xiaoming | | physics |
| | xiaoming | beijing | | xiaoming | | astronaut |
| | xiaoming | beijing | | xiaoming | | english |
| | xiaobai | shandong | | xiaobai | | astronaut |
| | xiaohong | suzhou | | xiaohong | | shuxue |
| | xiaohong | suzhou | | xiaohong | | english |
| | xiaohong | suzhou | | xiaohong | | physics |
| | xiaohong | suzhou | | xiaohong | | astronaut |
| | xiaohei | changchun | | xiaohei | | shuxue |
| | xiaohei | changchun | | xiaohei | | physics |
| NULL | NULL | NULL | | .2xiaobai | | english |
| NULL | NULL | NULL | | .2xiaobai | | physics |
| NULL | NULL | NULL | | 3xiaobai | | shuxue |
| NULL | NULL | NULL | | 123xiaohei | | astronaut |
| NULL | NULL | NULL | | .12xiaohei | | english |
+------+----------+-----------+----+------------+-------+-----------+
rows in set (0.00 sec)
最新文章
- SQL Server 2012 新特性:包含数据库访问数据库引擎
- ajax 同步和异步
- Vue.js之v-for
- 限制action所接受的请求方式或请求参数
- Android 中PopupWindow使用 (转)
- 纯css3样式属性制作各种图形图标
- HTML的表格标签
- apache2: Could not reliably determine the server's fully qualified domain name
- 《MFC游戏开发》笔记九 游戏中的碰撞判定初步&;怪物运动简单AI
- storm实战总结笔记
- iOS LaunchScreen和LaunchImage的转换启动图
- Linux入门(1)_VMware和系统分区和系统安装和远程登陆管理
- nodejs操作mysql常见错误
- docker镜像加速器
- [No0000118]SQL Server附加数据库拒绝访问解决方法汇总
- Python基础教程之udp和tcp协议介绍
- 数据驱动 vs 关键字驱动:对搭建UI自动化测试框架的探索
- AIX查询当前目录下各文件及目录大小
- JPA查询
- WebVTT 及 HTML5 <;track>; 元素简介