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