mysql query to generate weekly report store wise -
visitor trend between 2 date,result in weekly manner..
hard answer question without little more context, have @ datetime functions in mysql:
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_week
a simple group week(datefld)
take care of "weekly" aspect of question, statistical/mathematical functions need depend on specific case:
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html
Comments
Post a Comment