首页 > 代码库 > mysql not in 和 not exits

mysql not in 和 not exits

not exists 版本
SELECT
  org.*,
  u.rname AS uname
FROM
  exam_org org
  LEFT JOIN exam_user u
    ON org.ouid = u.uno WHERE NOT EXISTS
    (SELECT
      id
    FROM
      exam_org
    WHERE id IN (8,0)
      AND id = org.id)


not in 
SELECT
  org.*,
  u.rname AS uname
FROM
  exam_org org
  LEFT JOIN exam_user u
    ON org.ouid = u.uno WHERE id not in(8,0)
    
由此可见,对于没有子查询来说 ,not innot exists 应该是差不多的

 

mysql not in 和 not exits