mysql统计网站每天的访问量

SELECT 
DATE_FORMAT(visit_date,'%Y-%m-%d') AS days,
COUNT(*) AS counts 
FROM wx_visitcount 
WHERE 
DATE_FORMAT(visit_date,'%Y-%m-%d') <= '2015-04-15'  

GROUP BY DAY(visit_date); 

我的个人网站：www.xiangqinlove.com