how to convert row to column in mysql

Question

Hai i need to convert row into column in mysql without using case

Yogendra Bhardwaj · Answer

If it's just a one-time activity export data into excel and after converting in desired format import back into mysql

snowal raj · Answer

Thank u Amit But I need in Mysql

Amit Kumar · Answer

Hi For your requirement you have to use pivot in sql. use this query. SELECT * FROM ( SELECT [store] [week] [amount] FROM [dbo].[order] ) a pivot ( SUM(amount) FOR WEEK in ([1] [2] [3][4][5][6]) ) pivb output :

snowal raj · Answer

Hai  This Is my Data store week amount 102 1 96 101 1 138 105 1 37 109 1 59 101 2 282 102 2 212 105 2 78 109 2 97 105 3 60 102 3 123 101 3 220 109 3 87 and i want Store 1 2 3 4 5 6 101 138 282 220 102 96 212 123 105 37 109

Amit Kumar · Answer

Hi Your requirement is not clear tell in details or can u provide snapshot?

Shweta Lodha · Answer

Do you mean you want ot insert data row in mysql table's column?