选择 2 列并合并数据 [英] Select 2 column and merge data

问题描述

我想将 col1 中的相同值与 col2 中的特定数据合并，并将其显示在 html 表中.我的sql表是这样的

I want to merge the same value in col1 and with there specific data in col2 and display it in html table. My sql table looks like this

+------+------+
|col1  |col2  |
+------+------+
|1     |test  |
+------+------+
|2     |test1 |
+------+------+
|1     |test2 |
+------+------+
|1     |test4 |
+------+------+
|2     |test8 |
+------+------+

预期的结果在html表格中是这样显示的.

The expected result is displayed in html table like this.

+------+------+
|      |test  |
|      |      |
|  1   |test1 |
|      |      |
|      |test2 |
+------+------+
|      |test4 |
|  2   |      |
|      |test8 |
+------+------+

推荐答案

您的示例数据不明确，但您可能正在寻找 GROUP_CONCAT:

Your sample data is not explicit, but you might be looking for GROUP_CONCAT:

SELECT 
    col1,
    GROUP_CONCAT(col2 SEPARATOR '
') col2
FROM mytable 
GROUP BY col1
ORDER BY col1

这篇关于选择 2 列并合并数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！