Tagged: sql

Mysqlx250 3

MySql query to dynamically convert rows to columns

In some cases pivoting a table is not desired, instead we need to convert rows to columns and append them to the result set without “grouping” them against a specific value. In some cases we simply need to append a column, or columns, for each row and name the new columns something arbitrary like data1, data2, data3, etc.