合并MySQL重复项和保持内容

Question

I have a MySQL table that looks like this:

ID   Email
1    [e-mail]
1    [e-mail]
1    [e-mail]
2    [e-mail]
2    [e-mail]

I would like to merge by ID but keep the "Email" data in the same cell:

ID   Email
1    [e-mail], [e-mail], [e-mail]
2    [e-mail], [e-mail]

How would you advise me to do that?

Answer 1

try

  "INSERT INTO NEW_TABLE (ID, EMAIL) 
      SELECT ID, GROUP_CONCAT(EMAIL)AS EMAIL 
      FROM OLD_TABLE 
      GROUP BY ID"