mysql 连接

左连接

select * from student as ta left join teacher on ta.id=teacher.id; 
select * from student left join teacher on student.id=teacher.id;