mysql单表查询根据耨以字段获取每年数据总数据量 SELECT COUNT(1) AS countNumber, YEAR(created_at) AS dateTime,school_id FROM log WHERE school_id>0 GROUP BY dateTime, school_id; 执行结果: