This code will convert (pivot) your MySQL database table from rows to columns.
Here is an example of what this code will do:
Original Table
ID | Name | Color |
---|---|---|
1 | James | Blue |
2 | Amy | Red |
Converted Table
ID | 1 | 2 |
---|---|---|
Name | James | Amy |
Color | Blue | Red |