查询到的唯一结果如何行列转化

[xyz_hy]

如图为 select fai1,fai2,fai3,fai4,fai5 from cmm_record where id=2 查询到的唯一结果，

如何转化成下面的方式,


FAI(别名) 值
fai1 29.692
fai2 68.739
fai3 66.782
fai4 31.440

[csdn_castiel]

select 'fai1' as 'FAI(别名)',fai1 as '值' from cmm_record where id=2 union all select 'fai2' as 'FAI(别名)',fai2 as '值' from cmm_record where id=2 union all select 'fai3' as 'FAI(别名)',fai3 as '值' from cmm_record where id=2 ......

[xyz_hy]

引用 1 楼 csdn_castiel 的回复:

select 'fai1' as 'FAI(别名)',fai1 as '值' from cmm_record where id=2
union all
select 'fai2' as 'FAI(别名)',fai2 as '值' from cmm_record where id=2
union all
select 'fai3' as 'FAI(别名)',fai3 as '值' from cmm_record where id=2
......

谢谢，，恍然大悟啊。。。。。。