[摘要]+------+----------------------------------+3 rows in set (0.00 sec)以id分组，把去冗余的name字段的值打印在一行，逗号分隔mys...
+------+----------------------------------+
3 rows in set (0.00 sec)
以id分组，把去冗余的name字段的值打印在一行，
逗号分隔
mysql> select id,group_concat(distinct name) from aa group by id;
+------+-----------------------------+
关键词：容易介绍mysql中concat函数与mysql在字段前/后增加字符串的示例代码