Sum Total Per Day

Databases
1

Hi Guys,

I have a database which has new records added every day, on each record there is a time stamp called TimeStamp and has info like this:

2013-11-11 08:00:53

I want a query which will count how many records there are for each day, so for example:

2013-11-11 = 102 records
2013-11-10 = 211 records
2013-11-09 = 163 records
etc…

I’m not sure how id do this but any help would be great.

Thank you…!

2

Something with DATE(), COUNT() and GROUP BY

3

Done it thanks :slight_smile:

SELECT COUNT( * ) , DATE_FORMAT(  `TimeStamp` ,  "%Y-%m-%d" ) AS Total_Leads
FROM data
GROUP BY Total_Leads