sql - How do I generate a series of hourly averages in MySQL? -

In my table, the data is found in a ten minute interval:

  2009-01 - 26 00:00:00 12 2009-01-26 00:10:00 1.1 2009-01-26 00:20:00 11 2009-01-26 00:30:00 09.06-26 00:40: 00 5 2009-01-26 00:50:00 3.4 2009-01-26 01:00:00 7 2009-01-26 01:10:00 7 2009-01-26 01:20:00 7.2 2009-01- 26 01:30:00 3 2009-01-26 01:40:00 25 2009-01-26 01:50:00 4 2009-01-26 02:00:00 3 2009-01-26 02:10:00 4 e.t.c.  

Is it possible to prepare a SQL-query, which will return a measurable chain in each hour?

In this case it should be returned:

  5.42 8.87 etc.  

This is unclear whether or not you want to accumulate on an average days.

If you want a different average for midnight on the 27th of the 26th midnight, then replace this kind of query of MbaVi:

  Select AVG (Value), from time to time hours by group (time), HOR (time)  

extra note () in the group Without any clause, the total data of the 00:00 to 00:59 in relation to the date of the query will be average together.