I have a MySQL table that looks like this:
ID Email
1 xx@xx.com
1 yy@yy.com
1 zz@zz.com
2 aa2@aa.com
2 bb@bb.com
I would like to merge by ID but keep the "Email" data in the same cell:
ID Email
1 xx@xx.com, yy@yy.com, zz@zz.com
2 aa2@aa.com, bb@bb.com
How would you advise me to do that?
try
"INSERT INTO NEW_TABLE (ID, EMAIL)
SELECT ID, GROUP_CONCAT(EMAIL)AS EMAIL
FROM OLD_TABLE
GROUP BY ID"