您的位置: 首页  >  IT文章  >  mysql in 子查询 效率慢，对比

mysql in 子查询 效率慢，对比

分类: IT文章 • 2022-05-05 19:09:44 
 desc SELECT id,detail,groupId from hs_knowledge_point where groupId in (
    SELECT groupId from hs_knowledge_point where groupId>0 GROUP BY groupId HAVING COUNT(groupId) > 1 
    UNION all
    SELECT groupId from hs_knowledge_point_commit where groupId>0 GROUP BY groupId HAVING COUNT(groupId) > 1 
)
UNION ALL
SELECT id,detail,groupId from hs_knowledge_point_commit where groupId in (
    SELECT groupId from hs_knowledge_point where groupId>0 GROUP BY groupId HAVING COUNT(groupId) > 1 
    UNION all
    SELECT groupId from hs_knowledge_point_commit where groupId>0 GROUP BY groupId HAVING COUNT(groupId) > 1 
)
View Code 
SELECT id,detail,groupId from hs_knowledge_point where groupId in (
    select groupId from (
        SELECT groupId from hs_knowledge_point where groupId>0 GROUP BY groupId HAVING COUNT(groupId) > 1 
        UNION all
        SELECT groupId from hs_knowledge_point_commit where groupId>0 GROUP BY groupId HAVING COUNT(groupId) > 1 
    ) tmp
)
UNION ALL
SELECT id,detail,groupId from hs_knowledge_point_commit where groupId in (
    select groupId from (
        SELECT groupId from hs_knowledge_point where groupId>0 GROUP BY groupId HAVING COUNT(groupId) > 1 
        UNION all
        SELECT groupId from hs_knowledge_point_commit where groupId>0 GROUP BY groupId HAVING COUNT(groupId) > 1 
    ) tmp
)
View Code

mysql in 子查询 效率慢，对比

mysql in 子查询 效率慢，对比

mysql in 子查询 效率慢，对比

mysql in 子查询 效率慢，对比

相关推荐