캘린더를 view로 생성해주고 싶은데요.

하드코딩말고 다른방법이 없나요?... 

    ALGORITHM = UNDEFINED 

    DEFINER = `AAA`@`%` 

    SQL SECURITY DEFINER

VIEW `taaadb`.`mmmm` AS

    SELECT _UTF8'2015-05-01' AS `yyyymmdd` 

    UNION ALL SELECT _UTF8'2015-05-02' AS `2015-05-02` 

    UNION ALL SELECT _UTF8'2015-05-03' AS `2015-05-03` 

    UNION ALL SELECT _UTF8'2015-05-04' AS `2015-05-04` 

    UNION ALL SELECT _UTF8'2015-05-05' AS `2015-05-05` 

    UNION ALL SELECT _UTF8'2015-05-06' AS `2015-05-06`