Discuss / SQL / FULL OUTER JOIN一直ERROR？win10什么原因？
Back

FULL OUTER JOIN一直ERROR？win10什么原因？

Topic source

石年618

#1 Created at ... [Delete] [Delete and Lock User]

SELECT s.id,s.name,s.class_id,c.name class_name,s.gender,s.score FROM students s FULL 

OUTER JOIN classes c ON s.class_id = c.id;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to 

your MySQL server version for the right syntax to use near 'FULL OUTER JOIN classes c ON 

s.class_id = c.id' at line 1

你曾温润如玉

#2 Created at ... [Delete] [Delete and Lock User]

mysql中没有full outer join的语法;

要实现全外连接,通过一次左连接和一次右连接,然后把两次的结果union

闲来舞剑

#3 Created at ... [Delete] [Delete and Lock User]

谢谢评论区，用的时候出错，就知道评论区有真相：）

忽如远行客

#4 Created at ... [Delete] [Delete and Lock User]

mysql 不支持FULL OUTER JOIN语法，只能左右连接两次结果UNION起来

SELECT s.id, s.name, s.class_id, c.name class_name, s.gender, s.score 
FROM students s RIGHT JOIN classes c 
ON class_id = c.id 
UNION 
SELECT s.id, s.name,s.class_id, c.name class_name, s.gender, s.score 
FROM students s LEFT JOIN classes c 
ON class_id = c.id;
  • 1

Reply