Mutual exchange in SQL?

Question

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

3 Answers

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

2 answers

Will give you access to instagram api service for mutual exchange of likes and subscriptions?

asked May 10, 2019 by KalupinMaksim

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

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

Mutual exchange in SQL?

Please log in or register to add a comment.

Please log in or register to answer this question.

3 Answers

Please log in or register to add a comment.

Please log in or register to add a comment.

Please log in or register to add a comment.

Related questions

Most popular tags