Row for each hour even if there is no record
- by peku33
I've got a trouble with creating mysql Query.
My PHP script executes this query on each run:
INSERT INTO Executes SET UserIp='%s' (%s is user IP)
Executes table is:
ExecuteId UNSIGNED BIGINT AI PRIMARY
Date TIMESTAMP DEFAULT CURRENT_TIMESTAMP INDEX
UserIp CHAR(24) ... | Some Columns
I want to retrive number of Executes in each hour. The most…