Transpose rows into columns in MySQL

Question

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

Depending upon what exactly you need you might need to use a PIVOT technique. In MySQL there is no inbuilt support so you need to use CASE statements. Can you provide a small example of source data and desired results? — Martin Smith
– Martin Smith, Commented Feb 9, 2011 at 10:26
for example , i am having a resultset with one col and 18 rows . how to convert them into 18 cols and 1 row — Even
– Even, Commented Feb 9, 2011 at 10:28
Right sounds like you are looking to transpose the whole thing. Pivot wouldn't do this. — Martin Smith
– Martin Smith, Commented Feb 9, 2011 at 10:29
This looks relevant, not sure if it's exactly a duplicate: stackoverflow.com/questions/1187460/sql-rows-to-columns — Piskvor left the building
– Piskvor left the building, Commented Feb 9, 2011 at 10:33

Dan Grossman · Accepted Answer · 2011-02-09 10:25:54Z

11

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

answered Feb 9, 2011 at 10:25

Dan Grossman

52.5k10 gold badges115 silver badges101 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Transpose rows into columns in MySQL

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related