mysql - 在mysql中一行显示来自一个ID的单词

Question

我有一个这样的表:

 ID | word
 ___________

 1  | hello
 1  | goodbye
 1  | goodnight
 2  | What
 2  | Why
 3  | Yes
 3  | No

有没有办法收集具有相同ID的单词并像这样在一行中显示:

 ID | word
 _______________________________

 1  | hello, goodbye, goodnight
 2  | What, Why
 3  | Yes, No

Answer 1

使用 GROUP_CONCAT()

SELECT ID, GROUP_CONCAT(word SEPARATOR ', ') word
FROM tableName
GROUP BY ID

• SQLFiddle Demo
• MySQL GROUP_CONCAT()

输出

╔════╦═══════════════════════════╗
║ ID ║           WORD            ║
╠════╬═══════════════════════════╣
║  1 ║ hello, goodbye, goodnight ║
║  2 ║ What, Why                 ║
║  3 ║ Yes, No                   ║
╚════╩═══════════════════════════╝