0610월 2016 by Truds No Comments [MYSQL] 날짜로 group by Database /* '%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 Read More