MySQL日期补全 查询近七天数据

MySQL日期补全 查询近七天数据

select * from ( 
select DATE_FORMAT(now(),'%m.%d') setime from dual
union all
select DATE_FORMAT(DATE_SUB(CURDATE(),INTERVAL 1 DAY),'%m.%d') setime from dual
union all
select DATE_FORMAT(DATE_SUB(CURDATE(),INTERVAL 2 DAY),'%m.%d') setime from dual
union all
select DATE_FORMAT(DATE_SUB(CURDATE(),INTERVAL 3 DAY),'%m.%d') setime from dual
union all
select DATE_FORMAT(DATE_SUB(CURDATE(),INTERVAL 4 DAY),'%m.%d') setime from dual
union all
select DATE_FORMAT(DATE_SUB(CURDATE(),INTERVAL 5 DAY),'%m.%d') setime from dual
union all
select DATE_FORMAT(DATE_SUB(CURDATE(),INTERVAL 6 DAY),'%m.%d') setime from dual
) t left join ...