sql 把列变成行显示

select max(case c.PeriodID WHEN 0 then c.gettime end) as t0,
	max(case c.PeriodID WHEN 0 then c.Value end) as p0,
    max(case c.PeriodID WHEN 1 then c.gettime end) as t1,
    max(case c.PeriodID WHEN 1 then c.Value end) as p1,
    max(case c.PeriodID WHEN 2 then c.gettime end) as t2,
    max(case c.PeriodID WHEN 2 then c.Value end) as p2,
    max(case c.PeriodID WHEN 3 then c.gettime end) as t3,
    max(case c.PeriodID WHEN 3 then c.Value end) as p3,
    max(case c.PeriodID WHEN 4 then c.gettime end) as t4,
    max(case c.PeriodID WHEN 4 then c.Value end) as p4,
    max(case c.PeriodID WHEN 5 then c.gettime end) as t5,
    max(case c.PeriodID WHEN 5 then c.Value end) as p5
     max(case c.PeriodID WHEN 6 then c.gettime end) as t6,
    max(case c.PeriodID WHEN 6 then c.Value end) as p6,
    MAX(c.Value),MIN(c.Value),Avg(c.Value)
from
(
	select gettime,a.`PeriodID`,a.`Value`
	from `rmbgms_bloodsugar` a
 		left join `rmbgms_period` b
   		 on a.`PeriodID`=b.`PeriodID`
	where  inStartTime<= gettime 
		and gettime < inEndTime
	GROUP by a.`PeriodID`, DATE_FORMAT(gettime,'%Y-%m-%d')
) c
group by DATE_FORMAT(c.gettime,'%Y-%m-%d');