SELECT
@s := @s + 1 AS `index`,
DATE_FORMAT( DATE_SUB( CURDATE(), INTERVAL @s MONTH ), '%Y-%m' ) AS `mon`
FROM
mysql.help_topic,
( SELECT @s := - 1 ) temp
WHERE
@s < 11
ORDER BY
mon DESC
查询最近七天的
SELECT
@s := @s + 1 AS `index`,
DATE_FORMAT( DATE_SUB( CURDATE(), INTERVAL @s DAY ), '%Y-%m-%d' ) AS `day`
FROM
mysql.help_topic,
( SELECT @s := - 1 ) temp
WHERE
@s < 6
ORDER BY
`day` DESC
