Is it possible I make a simple query to count how many records I have in a determined period of time like a Year, month or day, having a
TIMESTAMP field, like:
SELECT COUNT(id) FROM stats WHERE record_date.YEAR = 2009 GROUP BY record_date.YEAR
SELECT COUNT(id) FROM stats GROUP BY record_date.YEAR, record_date.MONTH
To have a monthly statistic.