I have row 1 and 2 which they are similar in records except status column.
+-----+------+-------+-----------+----------+---------+
| #id | NAME | STATUS| c_lan | Java_lan | Dot_lan |
+-----+------+-------+-----------+----------+---------+
| 1 | A | 111 | yes | Q | W |
| 1 | A | 222 | yes | Q | W |
+-----+------+-------+-----------+----------+---------+
Now is it possible to have these tow rows (1,2) become as one row as like below (need to merge status values in to one cell)?
+-----+------+-----------+-----------+----------+---------+
| #id | NAME | STATUS | c_lan | Java_lan | Dot_lan |
+-----+------+-----------+-----------+----------+---------+
| 1 | A | 111,222 | yes | Q | W |
+-----+------+-----------+-----------+----------+---------+
noting that i am considering this to be done on mysql view
Best Answer
Use GROUP_CONCAT() for this.
Your table:
Testcase:
View:
Test:
Obviously you may want to
GROUP
on more than justid
(depending on what you consider a "duplicate", and may want to order theGROUP_CONCAT()
in some way, but this points you in the right direction.Edit to address your comment: