极客教程MySQL 如何基于相应的重复ID值连接列？ 显示相同的值在同一列中，用斜杠分隔
为此，您可以使用GROUP_CONCAT（）。
让我们首先创建一个表 –
mysql> create table DemoTable764 (
ProductId int,
ProductPrice int
);
Query OK, 0 rows affected (0.56 sec)
使用插入命令将一些记录插入表中 –
mysql> insert into DemoTable764 values(101,10000);
Query OK, 1 row affected (0.12 sec)
mysql> insert into DemoTable764 values(102,1090);
Query OK, 1 row affected (0.14 sec)
mysql> insert into DemoTable764 values(103,4000);
Query OK, 1 row affected (0.15 sec)
mysql> insert into DemoTable764 values(102,3450);
Query OK, 1 row affected (0.19 sec)
mysql> insert into DemoTable764 values(101,20000);
Query OK, 1 row affected (0.14 sec)
mysql> insert into DemoTable764 values(104,50000);
Query OK, 1 row affected (0.12 sec)
使用select语句显示表中的所有记录 –
mysql> select *from DemoTable764;
这将产生以下输出 –
+-----------+--------------+
| ProductId | ProductPrice |
+-----------+--------------+
| 101 | 10000 |
| 102 | 1090 |
| 103 | 4000 |
| 102 | 3450 |
| 101 | 20000 |
| 104 | 50000 |
+-----------+--------------+
6 rows in set (0.00 sec)
以下是用于连接具有相应重复ID值的列的查询 –
mysql> select ProductId,
group_concat(ProductPrice SEPARATOR '/') AS ProductPrice from DemoTable764
group by ProductId;
这将产生以下输出 –
+-----------+---------------+
| ProductId | ProductPrice |
+-----------+---------------+
| 101 | 10000/20000 |
| 102 | 1090/3450 |
| 103 | 4000 |
| 104 | 50000 |
+-----------+---------------+
4 rows in set (0.00 sec)
阅读更多：MySQL 教程