mardi 1 mars 2016

Denormalize table and append data

I want to normalize the following table

+----+-------+
| ID | LINK  |
+----+-------+
|  1 |    43 |
|  1 |    55 |
|  1 |    98 |
|  2 |    66 |
|  2 |    23 |
+----+-------+

as

+-------+----------+
|  ID   |  LINK    |
+-------+----------+
| 1,1,1 | 43,55,98 |
| 2,2   | 66,23    |
+-------+----------+

How do I do it? What should be the query?

Aucun commentaire:

Enregistrer un commentaire