我有一个看起来像这样的表:
+----+----------+------------+
| id | server | name |
+----+----------+------------+
| 1 | server1 | PlayerOne |
| 2 | server2 | PlayerOne |
| 3 | server1 | PlayerTwo |
| 4 | server1 | PlayerFour |
+----+----------+------------+
我的目标是选择具有以下内容的数据:
+-----------+------------------+
| name | serverList |
+-----------+------------------+
| PlayerOne | server1,server2 |
+-----------+------------------+
我尝试SELECT server,name AS result
,但没有结果。
感谢任何能帮助我的人。