SELECT COUNT(DISTINCT ip),IP FROM LOG GROUP BY DATE_FORMAT(access_time,'%Y%m%d');
DATE_FORMAT(access_time,'%Y%m%d');按年月日进行分组
SELECT COUNT(DISTINCT ip),IP FROM LOG GROUP BY DATE_FORMAT(access_time,'%Y%m%d');
DATE_FORMAT(access_time,'%Y%m%d');按年月日进行分组