原始数据如下：
select * from test.t_test t;
转换sql：
select t.cpn_name as `单位名称`,
sum(if(t.device_name='夜视仪', t.total, 0)) as `夜视仪`,
sum(if(t.device_name='水壶', t.total, 0)) as `水壶`,
sum(if(t.device_name='警戒带', t.total, 0)) as `警戒带`,
sum(if(t.device_name='称重器', t.total, 0)) as `称重器`,
sum(if(t.device_name='路障', t.total, 0)) as `路障`,
sum(if(t.device_name='防爆毯', t.total, 0)) as `防爆毯`,
sum(if(t.device_name='发电机', t.total, 0)) as `发电机`
from test.t_test t group by t.cpn_name;
