数据库的列合并(一行多列合并为一列)

将tag1到tag5合并为一列，不是一行多列合并为一行一列，而是一行多列合并为一列。使用SQL语句：

SELECT KeyWorld1,sum(count)as countAll from 
( 
	select * from 
	(
	SELECT KeyWorld1,count(*) as count FROM (SELECT * from camera_name_keyword_analysis_result where idx=0) as table1  
	union  (SELECT KeyWorld1,count(*) from camera_name_keyword_analysis_result GROUP BY KeyWorld1)
	union  (SELECT KeyWorld2,count(*) from camera_name_keyword_analysis_result GROUP BY KeyWorld2)
	union  (SELECT keyWorld3,count(*) from camera_name_keyword_analysis_result GROUP BY keyWorld3)
	union  (SELECT keyWorld4,count(*) from camera_name_keyword_analysis_result GROUP BY keyWorld4)  
	union  (SELECT keyWorld5,count(*) from camera_name_keyword_analysis_result GROUP BY keyWorld5)    
	) as AllData  order by count DESC      #AllData是上面截取数据的别名，不加会出错
																#camera_name_keyword_analysis_result是表格名称，KeyWorld2到KeyWorld5是列名；

)  as AllDateWithOrder GROUP BY keyWorld1 order by countAll DESC ;


#  SELECT * from camera_name_keyword_analysis_result where idx=0    这一部分用于设置一个union开头，可以没有具体数据，后面5个带有union的sql语句才是联合的数据