1.mysql不支持FULL JOIN
SELECT * FROM a FULL JOIN b ON a.name=b.name
应该写成
SELECT * FROM a LEFT JOIN b ON a.name=b.name
UNION ALL
SELECT * FROM a RIGHT JOIN b ON a.name=b.name
1.mysql不支持FULL JOIN
SELECT * FROM a FULL JOIN b ON a.name=b.name
应该写成
SELECT * FROM a LEFT JOIN b ON a.name=b.name
UNION ALL
SELECT * FROM a RIGHT JOIN b ON a.name=b.name