remove rows after expiry date

[rshinwell]

Im creating a sql database which will store a username and password and a date of when the record was created. I then need mysql to remove the entry 1 hour after the record was created. (in effect, creating an expiry date for the username and password.)

Can mysql do this automatically without a php script doing the delete. I need this to be an automatic process eliminating the need for administration.

thanks for you help :-)

[notionlogic]

I guess you're looking for "scheduled MySQL processes" but I don't believe that's possible 🙁

On my site I have implemented some simple cron jobs that run PHP scripts to do something similar. However, if someone does know more then it might save my site from the extra administrative load ! 🙂