来自同一DB的Group_Concat()

Question

我正在对DB进行查询，希望将重复类别的组concat返回给我，例如在本表中

​

​

我希望从MySQL中的同一个表中获得与这种方式相同的级联父级的结果。

​

​

Answer 1

你好，请试一下：

CREATE TABLE Monopoly (Id INT,Name VARCHAR(30),Platform_ID INT,Parent_Name VARCHAR(30));
INSERT INTO Monopoly VALUES
(1, 'Rosatis', 1113080,'Rosatis Franchase'),
(2, 'Rosatis', 1113080,'Rosatis Global'),
(3, 'Rosatis', 1113080,'Rosatis USA'),
(4, 'Macianos Food', 1125676,'Rosatis Franchase'),
(5, 'Macianos Food', 1125676,'Rosatis Global'),
(6, 'Aurora BAR', 1452355,'Bar Grill Global'),
(7, 'Aurora BAR', 1452355,'USA Group'),
(8, 'Aurora BAR', 1452355,'Food Group');

完整法典：

SELECT M1.Id,M1.Name,M1.Platform_ID,M1.Parent_Name,Family_Name
FROM Monopoly M1
JOIN (SELECT Name, GROUP_CONCAT(DISTINCT Parent_Name) AS Family_Name FROM Monopoly GROUP BY Name) AS M2 ON M1.Name = M2.Name
GROUP BY Id,Name,Platform_ID,Parent_Name;

如果我们测试代码：

​

​