So, I've some type of records during my database that needs to be erased after 24 hrs. How do you make my MySQL database to update itself? Is even possible? Thanks

0 0 * * * mysql -u USER -pPASSWORD -h HOST DATABASE < path/to/sql/script

consider [cde]

You are able to write cron jobs for your.

In linux you should use crontab for your documentation

On Home windows you are able to set cron jobs like this