如果时间字段是正常的时间格式: 本文隐藏内容 - 星球会员可见 SELECT MONTH(日期列名) AS month, SUM(你要统计的数据的列名) AS total FROM table_name GROUP BY month; 如果时间字段是int类型的时间戳格式: 本文隐藏内容 - 星球会员可见 SELECT DATE_FORMAT(FROM_UNIXTIME(createtime), '%Y-%m') AS month, SUM(score) AS total FROM table_name GROUP BY month;