修改客户表 编号为 0101007002，0101007003的楼栋号 007-1-102，007-1-201
update gas_customer
set building= case
when govid=380 and customer_no=’0101007002′ then ‘007-1-102’
when govid=380 and customer_no=’0101007003′ then ‘007-1-201’
end
where
govid=380 and customer_no in (
‘0101007002’,
‘0101007003’
)