mysql转置_mysql行列转置，求sql

你这条sql 貌似还有问题吧 ，先参考这个 看看表名：table

字段：user , id , score

数据如下：

+----------+----------+----------------+

| user | id | score |

| u1 | 1 | 1.2 |

| u1 | 2 | 2.3 |

| u1 | 3 | 2.5 |

| u2 | 1 | 3.4 |

| u2 | 2 | 4.5 |

| u2 | 3 | 2.6 |

+----------+----------+----------------+

需要得到如下的查询结果：

+----------+----------------------+----------------------+----------------------+

| user | id_1_score | id_2_score | id_3_score |

| u1 | 1.2 | 2.3 | 2.5 |

| u2 | 3.4 | 4.5 | 2.6 |

+----------+----------------------+----------------------+----------------------+

SQL语句：

Select user,

sum(if(id=1, score,0)) as id_1_score,

sum(if(id=2, score,0)) as id_2_score,

sum(if(id=3, score,0)) as id_3_score

from table

group by user;