0

In MYSql, I have a table that looks like this:

[Id] [Col_names] [Values]
1    col_1        val_1
1    col_2        val_2
1    col_3        val_3
...
1    col_n        val_n

Basically, I want a query that returns me this output:

[col_1] ... [col_n]
val_1       val_n

Where the [Id] column identifies a single row (e.g., the observations of the [Values] column for all rows with Id = 1 corresponds to the values of the first row, the observations of the [Values] column for all rows with Id = 2 corresponds to the values of the second row and so on).

Barmar
  • 741,623
  • 53
  • 500
  • 612

0 Answers0