查询当前时间前的连续日期
SELECT
@num := @num + 1,
DATE_FORMAT(
ADDDATE(
DATE_SUB(
(
SELECT
DATE_FORMAT(
DATE_SUB(
now(),
INTERVAL dayofyear(now()) - 1 DAY
),
‘%Y-%m-%d’
)
),
INTERVAL 1 DAY
),
INTERVAL @num DAY
),
‘%Y-%m-%d’
) AS time
FROM
follow,
(SELECT @num := 0) t
WHERE
ADDDATE(
(
SELECT
DATE_FORMAT(
DATE_SUB(
now(),
INTERVAL dayofyear(now()) - 1 DAY
),
‘%Y-%m-%d’
)
),
INTERVAL @num DAY
) <= DATE_FORMAT(now(), ‘%Y-%m-%d’)
ORDER BY
time;