表 etpic
字段:picPatch ,picTitle, picNote
key:picid
--------------------------
想把多条等于picid的记录检成1条
想要结果:
picPatch1 ,picTitle1, picNote1,picPatch2 ,picTitle2, picNote2,
picPatchN ,picTitleN, picNoteN
怎么实现????????
字段:picPatch ,picTitle, picNote
key:picid
--------------------------
想把多条等于picid的记录检成1条
想要结果:
picPatch1 ,picTitle1, picNote1,picPatch2 ,picTitle2, picNote2,
picPatchN ,picTitleN, picNoteN
怎么实现????????
贴记录及要求结果出来看看
from etpic
where picid=123
+---+------+------+
| a | b | flag |
+---+------+------+
| 1 | A | 1 |
| 2 | B | 1 |
| 3 | C | 1 |
+---+------+------+
3 rows in set (0.00 sec)mysql> select group_concat(a,",",b,",",flag) from t1;
+--------------------------------+
| group_concat(a,",",b,",",flag) |
+--------------------------------+
| 1,A,1,2,B,1,3,C,1 |
+--------------------------------+
1 row in set (0.00 sec)mysql>