update test set priority=
(case when id=1 then
(select priority from test where id=2)
when id=2 then
(select priority from test where id=1) end)
where id=1 or id=2;
转载于:https://www.cnblogs.com/hubing/p/3520412.html
update test set priority=
(case when id=1 then
(select priority from test where id=2)
when id=2 then
(select priority from test where id=1) end)
where id=1 or id=2;
转载于:https://www.cnblogs.com/hubing/p/3520412.html