case-when导出透视表

导出模板

select 
	col1, 
	sum(case when col2 = 'key1' then 1 else 0 end) as 'key1',
 	sum(case when col2 = 'key2' then 1 else 0 end) as 'key2',
	count(id) 
	from `table_name` 
	group by col1;

导出表格样式为透视表

col1	key1	key2	count(id)
name1	value11	value12	value13
name2	value21	value22	value23