mysql不支持全连接，但可以通过左外连接+ union+右外连接实现

SELECT * FROM t1
LEFT JOIN t2 ON t1.id = t2.id
UNION
SELECT * FROM t1
RIGHT JOIN t2 ON t1.id = t2.id

mysql 实现全连接