mysql的内联接，左连接和右连接的区别

#在最后提供了自己演示的mysql语句，以供读者自行验证。
##两张表具体如下
表1:

表2

1. 内联（inner join)
   select * from link_teacher inner join link_student on link_teacher.id = link_student.id;
   结果等同于：
   select * from link_teacher, link_student where link_teacher.id = link_student.id;
   结果：把两个表中id相等的行拼接为一行显示出来。建议用前者，效率会高一些。
   

2. 左(外)联（left join 或者 left outer join)
   select * from link_teacher left join link_student on link_teacher.id = link_student.id;
   或者：
   select * from link_teacher left outer join link_student on link_teacher.id = link_student.id;