MYSQLはある時間帯の毎日の総数を統計する

1か月の会員総数を集計する

SELECT FROM_UNIXTIME(add_time, '%Y-%m-%e'), COUNT(*) AS count FROM member WHERE add_time BETWEEN UNIX_TIMESTAMP('2016-1-1 00:00:00') AND UNIX_TIMESTAMP('2016-1-31 00:00:00') GROUP BY FROM_UNIXTIME(add_time, '%Y%m%e') ORDER BY add_time;