在mysql查询中旋转
|
我们有下面给出的查询,输出如下:
mysql> select count(1) as cnt ,card.Program_ID program_id ,fd.load_type load_type ,
-> if(fd.load_type =0 ,concat(\'unload_cl_proram_\',card.program_id) ,concat(\'load_cl_proram_\',card.program_id)) as load_desc
-> from transaction_log_details fd inner join card card
-> on fd.Card_ID = card.Card_ID where card.Date_Created>=\'2011-01-01\' and card.Date_Created<=\'2011-06-01\'
-> and card.Program_ID in (4,5,6,7,8)
-> group by card.Program_ID,fd.load_type;
+-----+------------+-----------+--------------------+
| cnt | program_id | load_type | load_desc |
+-----+------------+-----------+--------------------+
| 5 | 4 | 0 | unload_cl_proram_4 |
| 14 | 4 | 1 | load_cl_proram_4 |
| 55 | 5 | 0 | unload_cl_proram_5 |
| 91 | 5 | 1 | load_cl_proram_5 |
| 13 | 6 | 0 | unload_cl_proram_6 |
| 29 | 6 | 1 | load_cl_proram_6 |
| 175 | 7 | 0 | unload_cl_proram_7 |
| 411 | 7 | 1 | load_cl_proram_7 |
| 61 | 8 | 0 | unload_cl_proram_8 |
| 161 | 8 | 1 | load_cl_proram_8 |
+-----+------------+-----------+--------------------+
10 rows in set (0.00 sec)
Now we want the output as follows: (some thing like pivot).
unload_cl_proram_4 load_cl_proram_4 unload_cl_proram_5 load_cl_proram_5 unload_cl_proram_6 load_cl_proram_6 unload_cl_proram_7 load_cl_proram_7 unload_cl_proram_8 load_cl_proram_8
5 14 55 91 13 29 175 411 61 161
没有找到相关结果
已邀请:
1 个回复
僻朵庙惩竣