[MYSQL] 날짜로 group by 2016년 10월 6일 0 comments /* '%Y%m%d' 혹은 '%Y-%m-%d' */ select date_format(articleregdt, '%Y%m%d') as date, count(*) from article group by date_format(articleregdt, '%Y%m%d') order by date asc date, group, mysql, 날짜