mysql查询最近七天时间

一、查询前七天时间

说明：如果要修改查询近8天、9天。修改 数字两处数字6

SELECT
	date_add(
	date_sub( ( SELECT DATE_SUB( curdate( ), INTERVAL 6 DAY ) ), INTERVAL 1 DAY ),
	INTERVAL ( cast( help_topic_id AS signed ) + 1 ) DAY 
	) dayStr 
FROM
	mysql.help_topic 
WHERE
	help_topic_id < DATEDIFF( NOW( ), date_sub( ( SELECT DATE_SUB( curdate( ), INTERVAL 6 DAY ) ), INTERVAL 1 DAY ) ) 
ORDER BY
	help_topic_id 

查询结果：
2021-08-14
2021-08-15
2021-08-16
2021-08-17
2021-08-18
2021-08-19
2021-08-20

关联查询

SELECT
	t.*,
	right(everyDay.dayStr,