SELECT
@s := @s + 1 AS index
,
DATE( DATE_SUB( DATE_FORMAT(‘2019-11-10’,’%Y-%m-%d’), INTERVAL @s DAY ) ) AS date
FROM
mysql.help_topic,
( SELECT @s := - 1 ) temp
WHERE
@s < 10
ORDER BY
date
DESC
函数
天DAY 周WEEK 月MONTH
SELECT
@s := @s + 1 AS index
,
DATE( DATE_SUB( DATE_FORMAT(‘2019-11-10’,’%Y-%m-%d’), INTERVAL @s DAY ) ) AS date
FROM
mysql.help_topic,
( SELECT @s := - 1 ) temp
WHERE
@s < 10
ORDER BY
date
DESC
函数
天DAY 周WEEK 月MONTH