MySQL Arrays:可以这样做吗?

2022-01-23 00:00:00 arrays concatenation subquery mysql

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

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.

相关文章