创立往年的12个月的视图：
CREATE ALGORITHM = UNDEFINED DEFINER = `root`@`%` SQL SECURITY DEFINERVIEW `year_month_view` ASSELECT CONCAT(DATE_FORMAT((CURDATE()), '%Y'),'-01') AS date UNIONSELECT CONCAT(DATE_FORMAT((CURDATE()), '%Y'),'-02') AS date UNIONSELECT CONCAT(DATE_FORMAT((CURDATE()), '%Y'),'-03') AS date UNIONSELECT CONCAT(DATE_FORMAT((CURDATE()), '%Y'),'-04') AS date UNIONSELECT CONCAT(DATE_FORMAT((CURDATE()), '%Y'),'-05') AS date UNIONSELECT CONCAT(DATE_FORMAT((CURDATE()), '%Y'),'-06') AS date UNIONSELECT CONCAT(DATE_FORMAT((CURDATE()), '%Y'),'-07') AS date UNIONSELECT CONCAT(DATE_FORMAT((CURDATE()), '%Y'),'-08') AS date UNIONSELECT CONCAT(DATE_FORMAT((CURDATE()), '%Y'),'-09') AS date UNIONSELECT CONCAT(DATE_FORMAT((CURDATE()), '%Y'),'-10') AS date UNIONSELECT CONCAT(DATE_FORMAT((CURDATE()), '%Y'),'-11') AS date UNIONSELECT CONCAT(DATE_FORMAT((CURDATE()), '%Y'),'-12') AS date
创立以后月前12个月的视图：
CREATE ALGORITHM = UNDEFINED DEFINER = `root`@`%` SQL SECURITY DEFINERVIEW `year_month_view` AS SELECT DATE_FORMAT(CURDATE(), '%Y-%m') AS `year_month` UNION SELECT DATE_FORMAT((CURDATE() - INTERVAL 1 MONTH), '%Y-%m') AS `year_month` UNION SELECT DATE_FORMAT((CURDATE() - INTERVAL 2 MONTH), '%Y-%m') AS `year_month` UNION SELECT DATE_FORMAT((CURDATE() - INTERVAL 3 MONTH), '%Y-%m') AS `year_month` UNION SELECT DATE_FORMAT((CURDATE() - INTERVAL 4 MONTH), '%Y-%m') AS `year_month` UNION SELECT DATE_FORMAT((CURDATE() - INTERVAL 5 MONTH), '%Y-%m') AS `year_month` UNION SELECT DATE_FORMAT((CURDATE() - INTERVAL 6 MONTH), '%Y-%m') AS `year_month` UNION SELECT DATE_FORMAT((CURDATE() - INTERVAL 7 MONTH), '%Y-%m') AS `year_month` UNION SELECT DATE_FORMAT((CURDATE() - INTERVAL 8 MONTH), '%Y-%m') AS `year_month` UNION SELECT DATE_FORMAT((CURDATE() - INTERVAL 9 MONTH), '%Y-%m') AS `year_month` UNION SELECT DATE_FORMAT((CURDATE() - INTERVAL 10 MONTH), '%Y-%m') AS `year_month` UNION SELECT DATE_FORMAT((CURDATE() - INTERVAL 11 MONTH), '%Y-%m') AS `year_month`