Tagged: pivot

pivot a table with dynamic columns in mysql 20

Pivot table with dynamic columns in MySQL

I have already written a post on how to pivot a table in MySQL, when the rows that we want to pivot into columns are somewhat predefined. Today I am going to show how you can achieve the same result, when the rows that we want to pivot into columns are not predefined but are dynamic instead