id='20151210144525'的用户Balance减少100, id='20151209173022'的用户Balance就增加100。
3. SQL语句
update bankaccount ba
set ba.balance =
(select a.balance
from (select ba.id,
case
when ba.id = '20151209173022' then
ba.balance + 100
when ba.id = '20151210144525' then
ba.balance - 100
else
ba.balance
end balance
from bankaccount ba) a
where ba.id = a.id)
where ba.id in ('20151209173022', '20151210144525');