SELECT
DATE(@cdate := DATE_ADD(@cdate, INTERVAL - 1 DAY)) as time
FROM
(SELECT @cdate := DATE_ADD(NOW(), INTERVAL + 1 DAY) FROM `表名`) t0
LIMIT 7
效果
SELECT
DATE(@cdate := DATE_ADD(@cdate, INTERVAL - 1 DAY)) as time
FROM
(SELECT @cdate := DATE_ADD(NOW(), INTERVAL + 1 DAY) FROM `表名`) t0
LIMIT 7
效果