Hi folks,
I have a MySql table...which has 4 columns say
sid pid tid data
1 abc
2 def
3 ghi
4 jkl
- -
10 xyz
1 dfsf
2 sdfs

I want to convert column name 'data' into multiple rows i.e.

1 2 3 4 5 --- 10 (Column Name)
abc def ghi jkl mno xyz (data in one row)


In short I want to break one column data into 10 column .


Any Ideas ????

sid data
1 abc
2 def
1 dfsf
2 sdfs

suppose above is the case in your table, then what result do you expect?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.