Novice ask for a date query statement

sc_ups

The column type is TIMESTAMP

I want to do a statistical query, with a monthly interval, that is, how many records are found in all records per month
For example, how many records are there every month from January 2015 to January 2016?
Please enlighten me, thank you.

sc_ups

Already done
By the way, share with you, I hope it will be helpful to novices, no need to read it

SELECT COUNT(*),YEAR(t),MONTH(t) FROM test GROUP BY YEAR(t),MONTH(t);

adslddn

select date_format(date,'%Y%M'),count(*)
from table
group by date_format(date,'%Y%M');