캘린더를 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`
|