MySQL列出最近x天的日期

SELECT @cdate := date_add( @cdate, INTERVAL - 1 DAY ) AS time FROM ( SELECT @cdate := date_add( DATE_FORMAT( NOW( ), "%Y-%m-%d" ), INTERVAL + 1 DAY ) FROM alarm_info ) tmp1 LIMIT 7；