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.
Example :
Suppose you have Student table with skill.
srno | student | skill |
1 | Jaydip | PHP |
2 | Sanjay | PHP |
3 | Jaydip | Android |
4 | Pratik | PHP |
5 | Sanjay | CI |
6 | Pratik | Magento |
Now you want to display like studentĀ with all skills in one row.
srno | student | allskill |
1 | Jaydip | PHP,Android |
2 | Sanjay | PHP,CI |
3 | Pratik | PHP,Magento |
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;