mysql join
内连接 inner join
左外连接 left join
右外链接 right join
内连接 inner join
左外连接 left join
右外链接 right join
交叉连接 cross join
a表:name_info
b表:hobby_info
1.内连接:根据条件取两个表的交集;
SELECT a.name,b.hobby from name_info a inner JOIN hobby_info b on b.id=a.id;
结果:
2.左外连接:以左边的表为基表,根据连接条件筛选数据,若右边表中没有匹配的则字段为空;
SELECT a.id,a.name,b.hobby from name_info a LEFT JOIN hobby_info b on b.id=a.id;
结果:
3.右外连接:以右边的表为基表,根据连接条件筛选数据,若左边表中没有匹配的则字段为空;
SELECT a.id a_id,a.name,b.hobby,b.id b_id from name_info a RIGHT JOIN hobby_info b on b.id=a.id;
结果:
SELECT a.id a_id,a.name,b.hobby,b.id b_id from name_info a CROSS JOIN hobby_info b ;
结果: