<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[studyl_happyeday的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/studyl_happyeday</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; studyl_happyeday]]></copyright><item><title><![CDATA[mysql多表联查之内连接、左连接、右连接以及全连接查询]]></title><link>https://blog.youkuaiyun.com/studyl_happyeday/article/details/120902172</link><guid>https://blog.youkuaiyun.com/studyl_happyeday/article/details/120902172</guid><author>studyl_happyeday</author><pubDate>Fri, 22 Oct 2021 17:11:01 +0800</pubDate><description><![CDATA[详细参考Mysql—— 内连接、左连接、右连接以及全连接查询_zjt980452483的博客-优快云博客_mysql 全连接

学习新得：

一、两表主键的值都一致，使用普通的两表查询

select * from 表1，表2 where 表1.主键=表2.主键

二、只有当主键的值 不一致，则需要筛选 是选择表1的值还是表2的值 使用连接

1、内连接 from 表a inner join 表b on a.主键=b.主键 取值：两表交叠部位





2、左连接 from 表a left ...]]></description><category></category></item></channel></rss>