A row for each column as MySQL select result

Asked Jan 14 '15 at 15:42

Active Jan 14 '15 at 15:42

Viewed 23 times

I have a table with following columns:

 x y z col1 col2 col3 ... col12

As a select result I want a row for each colX column. So this will result in 12 rows for each row:

 x y z col1
 x y z col2
 x y z col3
 ...
 x y z col12

Is this possible in MySQL and how should I start on this?

asked Jan 14 '15 at 15:42

Nathan Q

1

Converting columns into rows is called unpivot, the duplicate shows a few different ways to get the result. – Taryn Jan 14 '15 at 15:50
1

see here http://courses.oreillyschool.com/dba1/dba110.html – A l w a y s S u n n y Jan 14 '15 at 15:55

0 Answers0