mysql 行转列查询、列转行查询

一、行转列查询

行转列查询：同一行数据转换为同一列数据；使用联合合并方案【union】

原表：
SELECT t1.responsibility_name, t1.a_hour, t2.b_hour 
FROM (SELECT responsibility_name, responsibility_man, SUM(use_hour) a_hour 
	  FROM man_work_list WHERE doc_no='AA00261988' 
	  GROUP BY responsibility_name) t1 
JOIN (SELECT responsibility_name, responsibility_man, SUM(use_hour) b_hour 
	  FROM man_work_list WHERE doc_no='AA00262267' 
	  GROUP BY responsibility_name) t2 
on t1.responsibility_man=t2.responsibility_man;

行转列查询后的结果：
SELECT responsibility_name, myno, a_hour 'hour' 
FROM (SELECT t1.responsibility_name, 'a' AS myno, t1.a_hour 
      FROM (SELECT responsibility_na