mysql 날짜별 카운트 세기

select date_format(`reg_date`, '%Y-%m-%d') d, count(*) from table group by d; +------------+----------+ | d | count(*) | +------------+----------+ | 0000-00-00 | 6 | | 2015-11-15 | 2 | | 2015-12-21 | 3 | +------------+----------+ 3 rows in set (0.00 sec)

간단하게 월별 카운트

select date_format(`reg_date`, '%Y-%m') d, count(*) from table group by d; +---------+----------+ | d | count(*) | +---------+----------+ | 0000-00 | 15 | | 2015-12 | 33 | +---------+----------+ 2 rows in set (0.01 sec)