#内连接select * from auth_user u inner join auth_group g on u.id = g.id; #左连接select * from auth_user a left join
#内连接
select * from auth_user u inner join auth_group g on u.id = g.id;
#左连接
select * from auth_user a left join auth_group b on a.id = b.id;
#右连接
select * from auth_user a right join auth_group b on a.id = b.id;
#左链接-内连接
select * from auth_user a left join auth_group b on a.id = b.id where b.id is null;
#右连接-内连接
select * from auth_user a right join auth_group b on a.id = b.id where b.id is null;
#Mysql外连接不让使用full join 或者full outer join
--结束END--
本文标题: MySQL的join使用
本文链接: https://www.lsjlt.com/news/3082.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-12
2024-05-12
2024-05-12
2024-05-12
2024-05-12
2024-05-12
2024-05-12
2024-05-11
2024-05-11
2024-05-11
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0