sql批量刷数据

努力的家伙是不讨厌的

于 2023-08-15 17:37:13 发布

阅读量619

点赞数

文章标签： sql 数据库

本文链接：https://blog.csdn.net/weixin_45386898/article/details/132303781

版权

文章描述了如何更新两个数据库表（gd_lzxx_bztjbb_zbzb和gd_wxba）的状态，通过查询特定时间范围内的操作步记录，为没有状态的条目设置相应的办结状态和时间。涉及到SQL查询和数据关联操作。

摘要由CSDN通过智能技术生成

应用场景

== 新增了一个字段，老数据的该字段都为空，值需要从其他表里去取 ==

解决方法

update gd_lzxx_bztjbb_zb zb
   set gdstatus = '4',
       gdbjr    = (select a.create_by
                     from (select gdid, create_by, create_time
                             from gd_operation_step
                            where create_time >=
                                  to_date('2023-04-20',
                                          'yyyy-MM-dd HH24:mi:ss')
                              and create_time <=
                                  to_date('2023-05-01',
                                          'yyyy-MM-dd HH24:mi:ss')
                              and (remark like '%在受理阶段决定办结%' or
                                  remark like '%在受理阶段自动办结%' or
                                  remark like '%在受理阶段转12345办结%')) a
                     left join gd_lzxx_bztjbb_zb b on a.gdid = b.gdid
                    where b.GDSTATUS is null
                      and zb.gdid = b.gdid),
       gdbjsj   = (select a.create_time
                     from (select gdid, create_by, create_time
                             from gd_operation_step
                            where create_time >=
                                  to_date('2023-04-20',
                                          'yyyy-MM-dd HH24:mi:ss')
                              and create_time <=
                                  to_date('2023-05-01',
                                          'yyyy-MM-dd HH24:mi:ss')
                              and (remark like '%在受理阶段决定办结%' or
                                  remark like '%在受理阶段自动办结%' or
                                  remark like '%在受理阶段转12345办结%')) a
                     left join gd_lzxx_bztjbb_zb b on a.gdid = b.gdid
                    where b.GDSTATUS is null
                      and zb.gdid = b.gdid)
 where gdid in (select b.gdid
                  from (select gdid, create_by, create_time
                          from gd_operation_step
                         where create_time >=
                               to_date('2023-04-20', 'yyyy-MM-dd HH24:mi:ss')
                           and create_time <=
                               to_date('2023-05-01', 'yyyy-MM-dd HH24:mi:ss')
                           and (remark like '%在受理阶段决定办结%' or
                               remark like '%在受理阶段自动办结%' or
                               remark like '%在受理阶段转12345办结%')) a
                  left join gd_lzxx_bztjbb_zb b on a.gdid = b.gdid
                 where b.GDSTATUS is null)
   and GDSTATUS is null

update gd_wxb a
   set ja_time = (select create_time
                    from (select create_time
                            from gd_wxb_operation_step
                           where gdid = a.id
                           order by create_time desc)
                   where rownum = 1)
 where id in (select id
                from gd_wxb
               where status = '2'
                 and del_flag = 0)