SELECT
DATE_FORMAT( DATE_ADD( NOW(), INTERVAL -(CAST( help_topic_id AS SIGNED INTEGER )) MONTH ), '%Y-%m' ) weeks
FROM
mysql.help_topic
WHERE
help_topic_id <6
ORDER BY weeks asc;
效果:
SELECT
DATE_FORMAT( DATE_ADD( NOW(), INTERVAL -(CAST( help_topic_id AS SIGNED INTEGER )) MONTH ), '%Y-%m' ) weeks
FROM
mysql.help_topic
WHERE
help_topic_id <6
ORDER BY weeks asc;
效果: