There are many ways to do this, but I don't know of an automagical or even a menu driven way to do it using just MySQL. You could schedule a job using your OS scheduler to do this. There are a number of add-ons for MySQL, and I'm sure that some of them (possibly PHP Admin) might do this for you.
-PatP