Append the data in multiple Rows to single row

[shivakrishna]

hi i need a query to format the data

the raw data is as follows

ID skills
1001 sql
1001 C++
1001 java
1002 unix
1002 C++
1003 rdbms
1003 java

and the result must be

ID skills
1001 sql , C++, java
1002 unix , C++
1003 rdbms , java

[coolsti]

Hint: look in the mysql documentation for the "group by" clause and the "group_concat() " function.