3 ms·
idk if this is what the parent had in mind, but this seems straightforward enough: update t set user_order = case when id = 123
by dllthomas 9y ago
idk if this is what the parent had in mind, but this seems straightforward enough:
update t
set user_order =
case
when id = 123
then 500
else user_order + 1
end
where id = 123 or user_order >= 500;