--同一张表两条记录互换
--update pm_roleinfo set rolename=a.rolename,rolecode=a.rolecode,remark=a.remark
--from
--(
--select roleid+2 as roleid,rolename,rolecode,remark from pm_roleinfo where roleid =3044
--union all
--select roleid-2 as roleid,rolename,rolecode,remark from pm_roleinfo where roleid =3046
--) a
--where pm_roleinfo.roleid=a.roleid
--update pm_roleinfo set rolename=a.rolename,rolecode=a.rolecode,remark=a.remark
--from
--(
--select roleid+2 as roleid,rolename,rolecode,remark from pm_roleinfo where roleid =3044
--union all
--select roleid-2 as roleid,rolename,rolecode,remark from pm_roleinfo where roleid =3046
--) a
--where pm_roleinfo.roleid=a.roleid
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
