Hi, I am trying to transfer values in one table to a new table with a different structure. The current table has 3 fields id, content_id and value and for each content_id there are several records.
I would like to transfer the values for each content_id to just 1 record on the new table but I am unsure how this could be done. I'm not sure I have explained it that great but hopefully this poor example will help.
id |cid| value
1 | 3 | a
2 | 3 | g
1 | 3 | a | g