My customer table is given below,
I need to transpose this table to customer_new
What is the easiest way.. I tried SELECT data and INSERT method, but is was difficult and more coding.
Any idea?
i tried , but not worked!
Asked
Active
Viewed 194 times
0
Tharindu ucsc
- 631
- 1
- 8
- 17
-
possible duplicate of [Transpose MySQL query - need rows into columns](http://stackoverflow.com/questions/13581482/transpose-mysql-query-need-rows-into-columns) – RandomSeed Jun 20 '13 at 06:32
-
What you are trying to do is known as a PIVOT which is not natively supported in MYSQL. See this:- http://stackoverflow.com/questions/13581482/transpose-mysql-query-need-rows-into-columns – Vivek Sadh Jun 20 '13 at 05:50
-
i tried but, not working – Tharindu ucsc Jun 20 '13 at 07:05
-
Then try again, because it is supposed to work :) What does not work? Please update your question with the query you have tried and a desription of the failure, if needed. – RandomSeed Jun 25 '13 at 23:47