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