Mutual exchange in SQL?

Question

3 Answers

0 like 0 dislike

1 answer

asked Apr 9, 2019 by Deefs

0 like 0 dislike

2 answers

asked May 10, 2019 by KalupinMaksim

0 like 0 dislike

1 answer

asked Jun 8, 2019 by eldar_web

0 like 0 dislike

1 answer

asked Apr 9, 2019 by myrslok

0 like 0 dislike

7 answers

asked Mar 28, 2019 by 2ball

longclaps · Answer 1 · 2019-04-18T09:03:43+0000

Well, if only 2 values:

UPDATE provodka SET code = 41003 - code; # 20501 + 20502 == 41003

M - Mosk )

Sanasol · Answer 2 · 2019-04-18T09:03:43+0000

First to replace the third-any.
Second to replace the first.
The third replaced by the second.

L - logic

If you're bored you in other ways.
\rhttps://tproger.ru/problems/popular-ways-to-swap/

alexalexes · Answer 3 · 2019-04-18T09:03:43+0000

Why not use the solution vlob?
Pass at the table only happens once.

UPDATE provodka p SET p.code = CASE when p.code = 20501 20502 then when p.code = 20501 20502 then else p.code END