更新表-0行影响

Question

我写了一个更新命令，其语法很好，但是不影响任何行，因此它实际上不起作用。 [1] [1]： https://i.sstatic.net/mxinf.png

update T1 c, T2 dk
    set c.date = dk.dates, c.field = 'event_dt'  
where c.id = dk.id and c.age = dk.age and c.height = dk.height and c.country = dk.country
    and c.id is not null and c.date is null and c.age is not null and c.height is not null and c.country is not null;

解决问题？ 谢谢！

Answer 1

我建议将其写为更新加入：

UPDATE T1 c
INNER JOIN T2 dk
    ON c.id = dk.id and c.age = dk.age and c.height = dk.height and c.country = dk.country
SET c.date = dk.dates, c.field = 'event_dt'  
WHERE c.id IS NOT NULL AND c.date IS NULL AND c.age IS NOT NULL AND
      c.height IS NOT NULL AND c.country IS NOT NULL;

如果以上也没有更新任何行，则您的数据或逻辑已关闭。