MySQL获取七天连续日期列表

select DATE_FORMAT(SUBDATE(NOW(),interval sntable.sn day),'%Y-%m-%d') as statDate
from (SELECT 0 as sn UNION SELECT 1 as sn UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6) sntable