Today, i am going to write first post for mySql. mySql has many functions to make programmer’s life easy.
When i was doing my project, i have to display some data by grouping with one field.
Suppose you have Student table with skill.
Now you want to display like student with all skills in one row.
To get result like this, GROUP_CONTACT is there in mySql.
GROUP_CONTACT Query :
SELECT srno,student,GROUP_CONTACT(skill) AS allskill FROM student_skill GROUP BY user;