由于我们无法在MySQL中使用INTERSECT查询，因此我们将使用EXIST运算符来模拟INTERSECT查询。可以通过以下示例来理解 –
示例
在此示例中，我们有两个表，即 Student_det%ign%ignore_a_1%re_a_1%l 和 Student_info，具有以下数据 –
mysql> Select * from Student_detail;+-----------+---------+------------+------------+| studentid | Name | Address | Subject |+-----------+---------+------------+------------+| 101 | YashPal | Amritsar | History || 105 | Gaurav | Chandigarh | Literature || 130 | Ram | Jhansi | Computers || 132 | Shyam | Chandigarh | Economics || 133 | Mohan | Delhi | Computers || 150 | Rajesh | Jaipur | Yoga || 160 | Pradeep | Kochi | Hindi |+-----------+---------+------------+------------+7 rows in set (0.00 sec)mysql> Select * from Student_info;+-----------+-----------+------------+-------------+| studentid | Name | Address | Subject |+-----------+-----------+------------+-------------+| 101 | YashPal | Amritsar | History || 105 | Gaurav | Chandigarh | Literature || 130 | Ram | Jhansi | Computers || 132 | Shyam | Chandigarh | Economics || 133 | Mohan | Delhi | Computers || 165 | Abhimanyu | Calcutta | Electronics |+-----------+-----------+------------+-------------+6 rows in set (0.00 sec)
现在，使用带有 WHERE 子句的 EXIST 运算符的以下查询将模拟 INTERSECT 以返回两个表中都存在的“studentid”、姓名、地址（其中名称不是“Yashpal”） –
mysql>Select Student_detail.studentid,Student_detail.name, student_detail.address FROM student_detail WHERE Student_detail.studentid >100 AND EXISTS (SELECT * FROM Student_info WHERE Student_info.Name 'Yashpal' AND Student_info.studentid = Student_detail.studentid AND Student_info.name = Student_detail.name);+-----------+--------+------------+| studentid | name | address |+-----------+--------+------------+| 105 | Gaurav | Chandigarh || 130 | Ram | Jhansi || 132 | Shyam | Chandigarh || 133 | Mohan | Delhi |+-----------+--------+------------+4 rows in set (0.00 sec)
以上就是我们如何模拟返回多个表达式的 MySQL INTERSECT 查询？的详细内容，更多请关注创想鸟其它相关文章！
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。
如发现本站有涉嫌抄袭侵权/违法违规的内容， 请发送邮件至 chuangxiangniao@163.com 举报，一经查实，本站将立刻删除。
发布者：程序猿，转转请注明出处：https://www.chuangxiangniao.com/p/100424.html
微信扫一扫 
支付宝扫一扫 
