automated trigger in MySQL

admin

Administrator
Staff member
Is it possible to do the following:

I want to setup a database where ppl can borrow something and they get a "bringback" date.
Now when that day arrives I want to send out a automated reminder when the borrowed item isn't returned yet, let's say at 00:00 hours.

I want the system to check this at 00:00 every day and when it finds items overdue it send ou the remindermail.


Can this be done and if so: HOW?

Thx
 
Back
Top