MySQL 日時ごとの集計まとめ - QiitaDeleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? 月別、日別、時間別にレコード数を集計 一月毎 mysql> SELECT DATE_FORMAT(カラム１, '%Y-%m') AS time, COUNT(*) AS count FROM テーブル名 GROUP BY DATE_FORMAT(カラム１, '%Y%m'); 一日毎 mysql> SELECT DATE_FORMAT(カラム１, '%Y-%m-%d') AS time, COUNT(*) AS count FROM テーブル名 GROUP BY DATE_FORMAT(カラム１, '%Y%m%d'); 一時間毎 mysq
