Transposing a SQL table

Question

MySQL

faced with the task of transposing a table (rotation by 90 degrees).
have columns
A | b | C
1 | 2 | 3
4 | 5 | 6

output
A 1 4
B 2 5
C 3 6

on the Internet they write
"my very strong advice: don't try to do this with SQL"
and a couple of rather "strange" options

What do you advise?

Answer 1

It's not entirely clear what type of data it is, but it's fashionable enough to solve using Dynamic SQL anyway.

Answer 2

A | b | C
1 | 2 | 3
4 | 5 | 6
output
A 1 4
B 2 5
C 3 6

Answer 3

A | b | C
1 | 2 | 3
4 | 5 | 6
rotations 90 degrees left:
C 3 6
B 2 5
A 1 4
right:
4 1 A
5 2 B
6 3 C
Transpose - Replace columns with rows, not rotate!

Answer 4

If there is not too much data and the task is one-time, the procedure is very simple:
1. Count everything.
2. Transpose.
3. Record everything.

Answer 5

I wonder where such a task comes from.
By the way, DBMS, in fact, are able, in a sense, to transpose tables. This is called an "index".

Answer 6

It is unlikely that this will help you, but in MS-SQL this is done using the PIVOT function. Maybe google on "pivot in MySql" will help

Answer 7

when already a blunt muscle is to learn how to do it