我有下面这个样表
+---------+----------------------+
| PRODUCT | TYPE |
+---------+----------------------+
| WIN 10 | Home |
+---------+----------------------+
| WIN 10 | Pro |
+---------+----------------------+
| WIN 10 | Pro for Workstations |
+---------+----------------------+
| Linux | Ubuntu |
+---------+----------------------+
| Linux | Red Hat |
+---------+----------------------+
| Linux | Fedora |
+---------+----------------------+
我想改变它（转置）有结果如下所示使用MySQL
+---------+-------------------------------+
| PRODUCT | TYPE |
+---------+-------------------------------+
| WIN 10 | Home,Pro,Pro for Workstations |
+---------+-------------------------------+
| Linux | Ubuntu,Red Hat,Fedora |
+---------+-------------------------------+
你能帮我弄一下吗？ 我已经尝试了所有我可以使用这个论坛，但我不能得到我需要的结果，非常感谢你的帮助
在mysql中，可以使用group_concat
select product, group_concat(type)
from my_table
group by product
或由
select product, group_concat(type order by type)
from my_table
group by product
