后台批量更新安全库存等信息

创建无数据临时表
create table zhang_ as 
select ima01,ima27,ima271 from ima_file where 1=2
批量更新
update ima_file a set a.ima27= (select b.ima27  from zhang_ b where b.ima01=a.ima01),
                      a.ima271=( select b.ima271  from zhang_ b where b.ima01=a.ima01)
where a.ima01 in (select ima01 from zhang_)
验证数据
select a.ima01,a.ima27,a.ima271,b.ima27,b.ima271 from zhang_ b,ima_file a
where a.ima01=b.ima01
删除临时表
drop table zhang_
 
update ima_file a set (a.ima27,a.ima271) = (select b.ima27,b.ima271 from zhang b where b.ima01=a.ima01 ) where .....