登 录
mysql不支持全连接,但可以通过左外连接+ union+右外连接实现
SELECT * FROM t1
LEFT JOIN t2 ON t1.id = t2.id
UNION
RIGHT JOIN t2 ON t1.id = t2.id
抱歉!评论已关闭.