Mysql number of users per month
===

I have a mysql database with the schema with fields

username, timestamp

where timestamp is the date of last activity.

I would like to construct a query in mysql that will give me the number of records, broken up by month, for a specific user.


Thanks.