如何将下表转换成列显示？

[icemanpro]

| tpname | level | name |
|--------|-------|------|
| tp1 | 1 | a |
| tp1 | 2 | b |
| tp1 | 3 | c |
| tp2 | 1 | d |
| tp2 | 1 | e |


转换成

| tpname | level1 | level2 | level3 |
|--------|--------|--------|--------|
| tp1 | a | b | c |
| tp2 | d | e | |


sql 语句应该如何写？

已解决

drop table tb;
create TEMPORARY table tb(tpname varchar(10),`level` int,`name` varchar(10));

insert into tb
VALUES('tp1',1,'a'),('tp1',2,'b'),('tp1',3,'c'),('tp2',1,'d'),('tp2',2,'e');

select tpname,GROUP_CONCAT(level1) as aa,GROUP_CONCAT(level2) as bb,GROUP_CONCAT(level3) as cc from (
select tpname,
case when `level`=1 then name end as level1,
case when `level`=2 then name end as level2,
case when `level`=3 then name end as level3
from tb a
) as dd
GROUP BY tpname

[arnoldFu]

oracle 可以使用 pivot 动态生成列，mysql 不知道有没有，或者使用存储过程创建视图来做