Hi friends,
I need to create a table which refers the fields from an existing table as follows:
[CODE=mysql]Create table a (select content,sid, count(*) count from b group by content order by count desc limit 0,30)[/CODE]
This code works well and creates a table.
But the content field having different sid's for each value.
ex:
content sid
Apple 3
Apple 5
Apple 8
Mango 7
Mango 10.....
Is there any way to store the sid in comma separated values in mysql?
Like as follows:
content sid
Apple 3,5,8
Mango 7,10.....
Please, help me out.........
Thanx n Regards
Yas.......