CODEWITHSUNDEEP
mysqlpivot
Even
Even

Reputation: 411

Transpose rows into columns in MySQL

How can I convert rows into columns in a MySQL query?

Upvotes: 8

Views: 27891

Answers (1)

Dan Grossman
Dan Grossman

Reputation: 52372

You can turn rows into a column with GROUP_CONCAT, but you can't 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's a tutorial on writing the complicated queries to emulate the transposition:

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

Upvotes: 11

Related Questions