sql日期相关查询--当日至上月当天的日期列表

- ## sql查询日期–当前日期倒退至上个月当天的日期列表查询

数据库：mysql5.7
SQL语句：直接在navicat中查询即可

SELECT
	date_add(
		date_sub(
			(
				SELECT
					date_format(
						DATE_SUB(now(), INTERVAL 30 DAY),
						'%y-%m-%d'
					)
			),
			INTERVAL 1 DAY
		),
		INTERVAL (
			cast(help_topic_id AS signed) + 1
		) DAY
	) DAY
FROM
	mysql.help_topic
WHERE
	help_topic_id < DATEDIFF(
		(SELECT curdate()),
		date_sub(
			(
				SELECT
					DATE_SUB(now(), INTERVAL 30 DAY)
			),
			INTERVAL 1 DAY
		)
	)
ORDER BY
	help_topic_id