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 < 7 ORDER BY 'date' ;
mysql获取最近几天的日期
最新推荐文章于 2022-11-14 14:43:55 发布
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 < 7 ORDER BY 'date' ;