update consumer set
names=case id
/*when 1 then '5'*/
when 2 then '5'
end,
loginName=case id
when 1 then '6'
when 2 then '2'
end
where id in (1,2);
sql多个条件更新
最新推荐文章于 2022-12-07 16:44:33 发布
update consumer set
names=case id
/*when 1 then '5'*/
when 2 then '5'
end,
loginName=case id
when 1 then '6'
when 2 then '2'
end
where id in (1,2);