更新一列中的多行
更新一列中的多行
提问于 2019-06-13 03:37:01
因此，我希望能够使用每个唯一行的唯一值来更新一列中的多行。也就是说，我希望从另一个表中为person获取一个值，并使用该值来替换密码，并且我希望能够批量执行此操作
我有下面的代码。
Update PERSON
Set Person.PASSWD = CONTPOINT.FILEAS From CONTPOINT INNER JOIN PERSON on Person.SERIALNO = CONTPOINT.SERIALNO
WHERE CONTPOINT.CPTYPENO = 3 AND Person.SERIALNO in ('45822', '44281', '28241', '28241', '31415', '31415', '31415', '31415', '31415', '39318', '41677', '41681', '41682', '41683', '45604', '45604', '45713', '45807', '45807', '45822', '45822', '45822', '32808', '27435', '17665', '30109', '27111', '27111', '43114', '43114', '39097', '39097', '43574', '40114', '30787', '30787', '39096', '39095', '39095', '27137', '27135', '22003', '27135', '33532', '27136', '27134', '33532', '34085', '27134', '17515', '26152', '26152', '26152', '26152', '26152', '26152', '34902', '42296', '34903', '40538', '41599', '41599', '29586', '42236', '29585', '10436', '43119', '38967', '37942', '10625', '10625', '43580', '43580', '43579', '43579', '45386', '30838', '30838', '30838', '30838', '30838', '30838', '30838', '30838', '30838', '30842', '30842', '30841', '30841', '30841', '30841', '30841', '30841', '23488', '24142', '24142', '24142', '24142', '41358', '41358', '41358', '41358', '39538', '39538', '39538', '39538', '4280', '4280', '4280', '4280', '4280', '4280', '39353', '39352', '43758', '8134', '43758', '35447', '8135', '35447', '41019', '41019', '41019', '41019', '33624', '41107', '33624', '38185', '34810', '34810', '34810', '34810', '34810', '34810', '34030', '34289', '34289', '34289', '34289', '34289', '34289', '21508', '21508', '21508', '21508', '21508', '21508', '21508', '21508', '21508', '21760', '21508', '21508', '21508', '21508', '21508', '21508', '21508', '21508', '21508', '43980', '21509', '21509', '13229', '13229', '13229', '13229', '13229', '13229', '41932', '42585', '44781', '38865', '30354', '30354', '33307', '45397', '44752', '42731', '43490', '25466', '25466', '25466', '25466', '25466', '25466', '24230', '39453', '39453', '39453', '39453', '34522', '41595', '41595', '41595', '41594')页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/56569257
复制相关文章
相似问题