mysql相交

Question

我是 mysql 的新手，所以请多关照。我的脚本出现以下错误，我不确定它出了什么问题。

SELECT uoid 
FROM mint 
WHERE mint_id='6' and userid='3836'
INTERSECT 
SELECT id as uoid
FROM cats 
WHERE category='Health, Fitness' 
ORDER BY 1;

给予

#1064 - 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 'INTERSECT SELECT id as uoid FROM cats WHERE category='Health, Fitness'' at line 4

Answer 1

MySQL 没有 INTERSECT 关键字。参见 this question和 this one获取有关如何实现目标的建议。