所用语句:SELECT DATE_FORMAT(create_time, "%Y-%m-%d" ) AS datetimes,COUNT(*) FROM location_community WHERE DATE_FORMAT(create_time, "%Y-%m-%d" ) BETWEEN '2012-10-10' AND '2016-05-05' GROUP BY DATE_FORMAT(create_time, "%Y-%m-%d" ) ;
所用语句:SELECT DATE_FORMAT(create_time, "%Y-%m-%d" ) AS datetimes,COUNT(*) FROM location_community WHERE DATE_FORMAT(create_time, "%Y-%m-%d" ) BETWEEN '2012-10-10' AND '2016-05-05' GROUP BY DATE_FORMAT(create_time, "%Y-%m-%d" ) ;