- Mysql Automatic Reset Every 24 Hours Every Single Day
Mysql Automatic Reset Every 24 Hours Every Single Day
this is a question asked by a user who wants to know how to reset mysql every 24 hours a day and every month because he has a wallpaper website
Wed Oct 08, 2008
i have a quick question regarding my wallpaper dedicated server. i run a wallpaper website and i want to be able to reset my stats every 24hrs and every month to keep track of my users.
lets say for example that i have a mysql database table and in the sql query, i want to be able to find out if it has been more than twenty four hours (one day), if it has, i want the number of visits to reset to 1
how can i do that?