Transpose rows into columns in MySQL

Question

How to convert rows to columns in a MySQL query?

Answer 1

You can turn rows into a column with GROUP_CONCAT , but you cannot transpose whole result sets in any automatic way. You either write a query that produces each column manually, or you do it in an application.

Here is a tutorial on writing complex queries to emulate transpose:

http://www.artfulsoftware.com/infotree/queries.php#78