多表批量更新记录

 

 

--创建备份表
create table NATION_SCOREINFO_TEST as select * from NATION_SCOREINFO 
select * from nation_scoreinfo_test
--查询报名和成绩姓名不一样
select ne.uuid as neuuid ,ne.name,ns.name,ns.uuid as nsuuid from nation_examineedetail ne , nation_scoreinfo_test ns 
where
ns.isdel<>1
and ne.plan_uuid = ns.plan_uuid
and ne.uuid = ns.examinee_uuid
and ne.card_number = ns.idcard_number  --身份证
and ne.exam_card_num = ns.exam_card_num --准考证
and ne.name != ns.name  --姓名
and ne.status >=220 --生成准考证状态
and ns.plan_uuid = 'cbaa6d10-68a6-4ac2-8932-d7c00f16fd' 



--把成绩的姓名改成和报名一样姓名
update nation_scoreinfo_test ns set ns.name=(select ne.name from nation_examineedetail ne where 
        ne.plan_uuid = ns.plan_uuid
        and ne.uuid = ns.examinee_uuid
        and ne.card_number = ns.idcard_number  --身份证
        and ne.exam_card_num = ns.exam_card_num --准考证
        and ne.name <> ns.name  --姓名
        and ne.status >=220 --生成准考证状态
        )
where 
ns.isdel<>1 
and ns.plan_uuid = 'cbaa6d10-68a6-4ac2-8932-dc00f16fd' 
and exists (select 1 from nation_examineedetail ne where 
        ne.plan_uuid = ns.plan_uuid
        and ne.uuid = ns.examinee_uuid
        and ne.card_number = ns.idcard_number  --身份证
        and ne.exam_card_num = ns.exam_card_num --准考证
        and ne.name <> ns.name  --姓名
        and ne.status >=220 --生成准考证状态
        ) 

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值