mysql - 如何在 MySQL 中选择最近 30 天的日期？

Question

我能以某种方式在 MySQL 中列出最近 30 天的日期吗？不是来自表格!

例如我是这样想的:

SELECT date WHERE date BETWEEN SUBDATE(NOW(), INTERVAL 30 DAY) AND NOW();

这可能吗？

Answer 1

我从别人的代码中破解了这个，但它似乎有效:

SELECT DATE_FORMAT(m1, '%d %b %Y')
FROM (
SELECT SUBDATE( NOW() , INTERVAL 30 DAY) + INTERVAL m DAY AS m1
FROM (
select @rownum:=@rownum+1 as m from
(select 1 union select 2 union select 3 union select 4) t1,
(select 1 union select 2 union select 3 union select 4) t2,
(select 1 union select 2 union select 3 union select 4) t3,
(select 1 union select 2 union select 3 union select 4) t4,
(select @rownum:=-1) t0
) d1
) d2 
WHERE m1 <= now()
ORDER BY m1

原代码由 valex在这里:

How to get a list of months between two dates in mysql