unpivot in mysql

I have seen some of the examples we have for pivot and unpivot in mysql,where the rows and columns are changes accordingly, but i have a table like below

 table1

Month    Current            30 Days       30 - 60 Days
Apr-13   1375159316       34511076         6423821
May-13   71398540         5674629          4775687
Jun-13   1314130060       27364660         9328588

and want it to create a new table like below

table2

Month            Apr-13               May-13              Jun-13
Current         1375159316      71398540     1314130060
30 Days         34511076        5674629          27364660
30 - 60 Days     6423821       4775687         9328588

How can i achieve the above.
baishali debAsked:
Who is Participating?
 
arnoldCommented:
See the discussion at https://forums.mysql.com/read.php?10,379790.

another option is to handle this in the display/rendering.
0
All Courses

From novice to tech pro — start learning today.