按时间分组
SELECT DATE_FORMAT( cdate, "%Y-%m-%d" )
AS time,COUNT(id) AS total FROM wxC_user_t
GROUP BY DATE_FORMAT( cdate, "%Y-%m-%d" )
按时间分组
SELECT DATE_FORMAT( cdate, "%Y-%m-%d" )
AS time,COUNT(id) AS total FROM wxC_user_t
GROUP BY DATE_FORMAT( cdate, "%Y-%m-%d" )