mysql按月统计 电脑版发表于:2025/4/16 15:01 sql如下: ``` select DATE_FORMAT(create_datetime,'%Y-%m') AS year_month_format, COUNT(*) AS total_count from cisp_lesson_knowledge where model_status = 90 GROUP BY year_month_format ORDER BY year_month_format ```