sql多个条件更新

update consumer set names=case id/*when 1 then '5'*/when 2 then '5'end,loginName=case idwhen 1 then '6'when 2 then '2'endwhere id in (1,2);