修改客戶表 編號為 0101007002，0101007003的樓棟號 007-1-102，007-1-201 UPDATE gas_customerSET building= CASEWHEN govid=380 and customer_no='0101007002' THEN '007-1-1 ...
修改客戶表 編號為 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'
)
