Dynamic pivot tables (transform rows to columns)
Dynamic pivot tables (transform rows to columns) in MySql there is no function of automatically table transformation. Surely we can use some program (tool), which is able to connect to MySql and execute data transformation. But in this case we want to do it manually, and we have one variant – to write a query which will execute the data rotation in the table http://buysql.com/mysql/14-how-to-automate-pivot-tables.html http://stackoverflow.com/questions/10925445/mysql-select-dynamic-row-values-as-column-names-another-column-as-value http://stackoverflow.com/questions/10986031/sql-dynamic-view-with-column-names-based-on-column-values-in-source-table?rq=1