1

Topic: The schedule on stories of actions

Friends, there was such question, there is at me a table actions with fields:
id, action, time
id - AI
action - any number
time - timestamp mysql
The task is that:
To break all these records with an interval, for example, each hour. In this hour records should be added, that is if was two records with  5 and 10 that in line should be 15.

2

Re: The schedule on stories of actions

termostat;
GROUP BY did not learn?

3

Re: The schedule on stories of actions

SELECT sum (count), time from transactions group by hour (time)

Let's admit but how to make its more floppy, it is desirable that the interval was specified in a msec

4

Re: The schedule on stories of actions

termostat wrote:

SELECT sum (count), time from transactions group by hour (time)

Let's admit but how to make its more floppy, it is desirable that the interval was specified in a msec

Request incorrect.