MySQl 不支持FULL JOIN ,那我们如何在MySQl 实现FULL 功能呢? 通过UNION 来实现 FULL JOIN: SELECT * FROM a LEFT JOIN b ON a.name = b.name UNION SELECT * FROM a RIGHT JOIN b ON a.name = b.name;