Dotaz: Transponovanie

[samouk]

Mam tabulku v MySQL, napriklad:

+- ID -+ VALUE---+
| 1000 +  text01 |
| 1000 +  text02 |
| 1000 +  text03 |
| 1001 +  texta1 |
| .... +   ..... |
+----------------+

a potrebujem transponovat stlpec do riadku nasledovne:

+- ID -+ ---------VALUES--------+
| 1000 +  text01,text02,text03  |
| 1001 +  texta1,...            |
| .... +  ..................... |
+-------------------------------+

pricom pre jednotlive ID moze byt x VALUE.

Poradite ako to urobit?

---

---

Odpovědi

[blondak]

GROUP_CONCAT