Question

MySql所谓的全连接怎么实现

Answer 1

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

Answer 2

格式如下：
select * from a full join b on(a.xx=b.xx);