34,575
社区成员
发帖
与我相关
我的任务
分享
update d set id=case when id=1 then 10 when id=2 then 27 from aaa d
update d set id=case when id=1 then 10 when id=2 then 27 end from aaa d
update d set id=case when id=1 then 10 when id=2 then 27 end
update d set id = case when id=1 then 10 when id=2 then 27 end from aaa d
update d set id=case when id=1 then 10 when id=2 then 27 end --少了个END
from aaa d