SELECT
@s := @s + 1 AS 'index',
DATE( DATE_SUB( CURRENT_DATE, INTERVAL @s DAY ) ) AS 'date'
FROM
mysql.help_topic,
( SELECT @s := - 1 ) temp
WHERE
@s < 30
ORDER BY
'date';
结果:
SELECT
@s := @s + 1 AS 'index',
DATE( DATE_SUB( CURRENT_DATE, INTERVAL @s DAY ) ) AS 'date'
FROM
mysql.help_topic,
( SELECT @s := - 1 ) temp
WHERE
@s < 30
ORDER BY
'date';
结果: