MySQL Arrays:可以这样做吗? [英] MySQL Arrays: Can this be done?

问题描述

是否可以选择子查询返回的所有结果的串联?

Is it possible to select the concatenation of all the results returned by a subquery?

那么如果子查询返回多于一行，我可以以某种方式获得包含在单个字符串中的所有结果?

So if the subquery returns more than one row, I can somehow get all the results contained in a single string?

推荐答案

排序 of.您可以获得的是使用 GROUP_CONCAT.您可以使用它来使用 GROUP BY 通过您知道将正确分组结果集的列，然后使用该函数返回连接组.手册页应提供一些示例.

Sort of. What you can get is the concatenated result of all the rows that were grouped together using GROUP_CONCAT. You could use that to employ GROUP BY by a column that you know would group the result set correctly and then using the function to return the concated groups. The manual page should provide some examples.

这篇关于MySQL Arrays:可以这样做吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！