how to convert row to column in mysql

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

0

Thank u Amit,

But I need in Mysql

0

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 :

0

Hai ,

This Is my Data

and i want

0

Hi,

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

0

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

0