mysql视图

12月视图

select '12' AS `id`,date_format((curdate() + interval (-(month(curdate())) + 12) month),'%Y-%m') AS `MONTH` union all select '11' AS `id`,date_format((curdate() + interval (-(month(curdate())) + 11) month),'%Y-%m') AS `MONTH` union all select '10' AS `id`,date_format((curdate() + interval (-(month(curdate())) + 10) month),'%Y-%m') AS `MONTH` union all select '09' AS `id`,date_format((curdate() + interval (-(month(curdate())) + 9) month),'%Y-%m') AS `MONTH` union all select '08' AS `id`,date_format((curdate() + interval (-(month(curdate())) + 8) month),'%Y-%m') AS `MONTH` union all select '07' AS `id`,date_format((curdate() + interval (-(month(curdate())) + 7) month),'%Y-%m') AS `MONTH` union all select '06' AS `id`,date_format((curdate() + interval (-(month(curdate())) + 6) month),'%Y-%m') AS `MONTH` union all select '05' AS `id`,date_format((curdate() + interval (-(month(curdate())) + 5) month),'%Y-%m') AS `MONTH` union all select '04' AS `id`,date_format((curdate() + interval (-(month(curdate())) + 4) month),'%Y-%m') AS `MONTH` union all select '03' AS `id`,date_format((curdate() + interval (-(month(curdate())) + 3) month),'%Y-%m') AS `MONTH` union all select '02' AS `id`,date_format((curdate() + interval (-(month(curdate())) + 2) month),'%Y-%m') AS `MONTH` union all select '01' AS `id`,date_format((curdate() + interval (-(month(curdate())) + 1) month),'%Y-%m') AS `MONTH`

24小时视图

select '24' AS `id`,date_format((curtime() + interval (-(hour(curtime())) + 24) hour),'%H') AS `hour` union all select '23' AS `id`,date_format((curtime() + interval (-(hour(curtime())) + 23) hour),'%H') AS `hour` union all select '22' AS `id`,date_format((curtime() + interval (-(hour(curtime())) + 22) hour),'%H') AS `hour` union all select '21' AS `id`,date_format((curtime() + interval (-(hour(curtime())) + 21) hour),'%H') AS `hour` union all select '20' AS `id`,date_format((curtime() + interval (-(hour(curtime())) + 20) hour),'%H') AS `hour` union all select '19' AS `id`,date_format((curtime() + interval (-(hour(curtime())) + 19) hour),'%H') AS `hour` union all select '18' AS `id`,date_format((curtime() + interval (-(hour(curtime())) + 18) hour),'%H') AS `hour` union all select '17' AS `id`,date_format((curtime() + interval (-(hour(curtime())) + 17) hour),'%H') AS `hour` union all select '16' AS `id`,date_format((curtime() + interval (-(hour(curtime())) + 16) hour),'%H') AS `hour` union all select '15' AS `id`,date_format((curtime() + interval (-(hour(curtime())) + 15) hour),'%H') AS `hour` union all select '14' AS `id`,date_format((curtime() + interval (-(hour(curtime())) + 14) hour),'%H') AS `hour` union all select '13' AS `id`,date_format((curtime() + interval (-(hour(curtime())) + 13) hour),'%H') AS `hour` union all select '12' AS `id`,date_format((curtime() + interval (-(hour(curtime())) + 12) hour),'%H') AS `hour` union all select '11' AS `id`,date_format((curtime() + interval (-(hour(curtime())) + 11) hour),'%H') AS `hour` union all select '10' AS `id`,date_format((curtime() + interval (-(hour(curtime())) + 10) hour),'%H') AS `hour` union all select '09' AS `id`,date_format((curtime() + interval (-(hour(curtime())) + 9) hour),'%H') AS `hour` union all select '08' AS `id`,date_format((curtime() + interval (-(hour(curtime())) + 8) hour),'%H') AS `hour` union all select '07' AS `id`,date_format((curtime() + interval (-(hour(curtime())) + 7) hour),'%H') AS `hour` union all select '06' AS `id`,date_format((curtime() + interval (-(hour(curtime())) + 6) hour),'%H') AS `hour` union all select '05' AS `id`,date_format((curtime() + interval (-(hour(curtime())) + 5) hour),'%H') AS `hour` union all select '04' AS `id`,date_format((curtime() + interval (-(hour(curtime())) + 4) hour),'%H') AS `hour` union all select '03' AS `id`,date_format((curtime() + interval (-(hour(curtime())) + 3) hour),'%H') AS `hour` union all select '02' AS `id`,date_format((curtime() + interval (-(hour(curtime())) + 2) hour),'%H') AS `hour` union all select '01' AS `id`,date_format((curtime() + interval (-(hour(curtime())) + 1) hour),'%H') AS `hour`