mysql根据日期取不同表数据_MySQL：选择日期范围之间的所有日期并获取匹配日期的表格数据...

我通过修改解决方案中给出的获取所有日期的查询来解决这个问题.

以下查询返回所有日期,如果存在任何记录,则返回ID计数：

select d.date, count(v.id) from

(select adddate('1970-01-01',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) date from

(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0,

(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1,

(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2,

(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3,

(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t4) d

left join visitors v on d.date = v.date

where d.date between '2016-06-01' and '2016-06-30'

group by d.date

order by d.date

感谢获取日期范围到@mark-bannister和查询匹配结果的简单连接,排序得到解决方案.