Mutual exchange in SQL?


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
45 views
Given a table of transactions provodka
It is known that this table has transactions only with code 20501 and 20502.
How to replace all lines on 20501 20502, 20501 20502 on.

How to replace, for example 20501 20502 on, I understand. REPLACE( Code, 20501, 20502). Progressively replace does not work, because after the first replace in all rows is the value of 20502.
by | 45 views

3 Answers

0 like 0 dislike
Well, if only 2 values:
UPDATE provodka SET code = 41003 - code; # 20501 + 20502 == 41003

M - Mosk )
by
0 like 0 dislike
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/
by
0 like 0 dislike
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
by

Related questions

0 like 0 dislike
1 answer
Show only those who are mutual friends?
asked Apr 9, 2019 by Deefs
0 like 0 dislike
1 answer
As SQL to collect all mutual substitution?
asked Jun 8, 2019 by eldar_web
0 like 0 dislike
1 answer
Is there any free service with data on Russian mutual Funds?
asked Apr 9, 2019 by myrslok
0 like 0 dislike
7 answers
A social network with mutual learning of languages?
asked Mar 28, 2019 by 2ball

Most popular tags

javascript php css html jquery wordpress python linux web-development mysql android windows java layout c# computer-networks node.js cpp iron yii vue.js 1C-Bitrix react laravel django nginx system-administration search-engine-optimization api ubuntu the-it-education. ajax sql programming hosting cms design apache google-chrome bootstrap Vkontakte macos google network-administration git laptops algorithms regular-expressions unity-game-engine email angular database network-equipment software wooсommerce debian .net ios information-security video law-in-it browsers books parsing wi-fi game-development career htaccess postgresql telegram mikrotik mobile-development ruby-on-rails the-domain-name-system modx Yandex c json opencart Habr freelance vpn asp.net windows-server symfony bots hard-drives math qt DIY audio frontend payment-system bash electronics gulp.js user-interface docker online-shopping
110,608 questions
257,187 answers
0 comments
40,796 users