I have a table as follow:
datetime (datetime) count (int)
2012-12-27 09:22:15 5
2012-12-27 18:20:15 4
2012-12-27 23:19:15 3
2012-12-26 13:45:15 8
2012-12-26 04:56:15 7
2012-12-25 01:50:15 2
2012-12-25 12:02:15 1
In MySQL, how do I query if I wish to return sum(count) for everyday and result like below:
2012-12-27 12
2012-12-26 15
2012-12-25 3
you need to use DATE
function around the columnName DateTime
.
SELECT DATE(datetime) as DATE, SUM(`count`) totalCOunt
FROM tableName
GROUP BY DATE(datetime)
Here you go:
SELECT SUM(`count`) as date_count
FROM table_name
GROUP BY date_format( `datetime`, '%Y-%m-%d');
Note: If possible, avoid the usage of Keywords (count) as column names.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With