SELECT date
FROM counter_table
ORDER BY YEAR(date) DESC, MONTH(date) DESC
GROUP BY DATE_FORMAT(date, "%m-%y")
'Web Program > mysql' 카테고리의 다른 글
| mysql 명령어 (1) | 2011.06.01 |
|---|
Web Program/mysql
SELECT date
FROM counter_table
ORDER BY YEAR(date) DESC, MONTH(date) DESC
GROUP BY DATE_FORMAT(date, "%m-%y")
| mysql 명령어 (1) | 2011.06.01 |
|---|