Mohamed Shaban
Reputation: 43
PHP / MySQL database daily reset
I have a database on phpMyAdmin and I want to reset certain columns to the default value (0) every day at 7:00PM automatically.
Can any one help?
Upvotes: 0
Views: 443
Answers (1)
Mathias Bader
Reputation: 3836
Set up a cron job that executes an sql script in which you specify the sql code that resets the columns in question.
Upvotes: 1
Related Questions
- Database periodic cleansing
- Resetting data in MySql database
- MySQL 14 day reset query
- mySQL Clearing a database once a month
- Mysql reset number daily
- Reset MySQL value every day with PHP
- How to start with a clean db every day?
- Server to auto reset mysql table values at a specific time
- Need to reset database table every week
- Reset the database after 3 hrs & make it behave as a new database through php script