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 ????