MySQL: daily average value

I have a table with a 'timestamp' column and a 'value' column where the values are roughly 3 secon开发者_如何学JAVAds apart.

I'm trying to return a table that has daily average values.

So, something like this is what i'm looking for.

| timestamp  | average |
| 2010-06-02 |  456.6  |
| 2010-06-03 |  589.4  |
| 2010-06-04 |  268.5  |
etc...

Any help on this would be greatly appreciated.

---

SELECT DATE(timestamp), AVG(value)
FROM table
GROUP BY DATE(timestamp)

Since you want the day instead of each timestamp

---

 select DATE(timestamp), AVG(value)
 from TABLE
 group by DATE(timestamp)

---

This assumes that your timestamp column only contains information about the day, but not the time. That way, the dates can be grouped together:

select timestamp, AVG(value) as average
from TABLE_NAME
group by timestamp