查询每个月 每天的数量
SELECT COUNT(*),SUBSTR(t.created_at,1,10) FROM users t WHERE t.created_at LIKE '2014-04%' GROUP BY SUBSTR(t.created_at,1,10);
查询每个月 每天的数量
SELECT COUNT(*),SUBSTR(t.created_at,1,10) FROM users t WHERE t.created_at LIKE '2014-04%' GROUP BY SUBSTR(t.created_at,1,10);