SQL 随笔

我想更新A表中一个字段 条件是 A.ID 在 B表中没出现的
例如：
UPDATE A SET A.Status = -1 WHERE ID IN
(
  SELECT A.ID FROM A WHERE A.ID NOT IN ( SELECT B.ID FROM B )
  GROUP BY A.ID
)

update a set a.status= '-1'
where not exists (
select 1
from b where b.ID=a.ID)

---------------------------------------------------------------------------------------------------