Advanced Search

Return to Snippet

Revision: 40866
at February 9, 2011 02:53 by pflangan
Initial Code 
insert into sitestats_rollup(hitdatetime,hitid,hitcount) select date_format(hitDate, "%Y-%m-%d %h:00:00"), hitKey, count(*) from sitestats group by 1,2 on duplicate key update hitcount=hitcount+1;
Initial URL 









Initial Description














Initial Title





migrate from detailed stats to hourly stats









Initial Tags





mysql









Initial Language





MySQL