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