mysql中的join、left join和right join的用法

本篇內容介紹了“mysql中的join、left join和right join的用法”的有關知識，在實際案例的操作過程中，不少人都會遇到這樣的困境，接下來就讓小編帶領大家學習一下如何處理這些情況吧！希望大家仔細閱讀，能夠學有所成！

   
暫時先用兩個表來演示：
創建bro_cats表：
 
create table bro_cats( 
id int(11) not null auto_increment, 
name varchar(128) not null default '', 
desn varchar(128) not null default '',
primary key() 
);
創建bro_articles表：
 
create table bro_articles( 
id int not null auto_increment, 
cid int not null, 
name varchar(128) not null, 
content test not null, 
primary key(id) 
);
接下來我們向里邊插入數據
 
INSERT INTO bro_cats(name, desn) values(‘php’,’php demo’); 
 
INSERT INTO bro_cats(name, desn) values(‘jsp’,’jsp demo’); 
 
INSERT INTO bro_cats(name, desn) values(‘’,’asp demo’); 
INSERT INTO bro_articles(cid, name, content)  //php 類中 cid=1
 
values(1,’this article of php1’, ‘php content1’); 
 
INSERT INTO bro_articles(cid, name, content)  //php 類中 cid=1
 
values(1,’this article of php2’, ‘php content2’); 
 
INSERT INTO bro_articles(cid, name, content)  // 類中 cid=2
 
values(2,’this article of jsp’, ‘jsp content’); 
 
INSERT INTO bro_articles(cid, name, content)  //asp 類中 cid=3
 
values(3,’this article of asp1’, ‘asp content1’); 
 
INSERT INTO bro_articles(cid, name, content)  //asp 類中 cid=3
 
values(3,’this article of asp2’, ‘asp content2’); 
下一步我們就用join語句測試一下
 
左聯接：left join 
select bro_cats.name as catsname,bro_cats.desn as description,bro_articles.name as articlesname,bro_articles.content as articlecontent from bro_cats left join bro_articles on bro_cats.id = bro_articles.cid; 
右聯接：right join 
select bro_cats.name as catsname,bro_cats.desn as description,bro_articles.name as articlesname,bro_articles.content as articlecontent from bro_cats right join bro_articles on bro_cats.id = bro_articles.cid; 
聯接：join 
select bro_cats.name as catsname,bro_cats.desn as description,bro_articles.name as articlesname,bro_articles.content as articlecontent from bro_cats join bro_articles on bro_cats.id = bro_articles.cid;
具體的這三個是什么效果，我還是建議大家試一下比較一下自己得出結論。

“mysql中的join、left join和right join的用法”的內容就介紹到這里了，感謝大家的閱讀。如果想了解更多行業相關的知識可以關注億速云網站，小編將為大家輸出更多高質量的實用文章！