tutorial for creating a trigger in MySQL

[lhugh]

does anybody know where I can find a tutorial on creating trigger in MySQL

I have a fied called expiry_date, I want to create a trigger on this field and that if the current date is a month prior to expiry date, my database will send an email to remind the system admin to do something.

Where can I find some tutorial like that?

Thank you all for your help

 

[TonyGroves]

Sorry, can't be done. According to the MySQL manual, triggers are planned for the future, but don't hold your breath.

 

[bastienk]

could create a cron job to run a small script at night (or whenever) to run the same check and send the email.

PHP, ASP whatever...

Cat, the other other white meat

 

[lhugh]

Thanks

 

[PROFESSORSPARKIE]

You could write a batch perl program that used a looping “sleep” command to pause, and then when the “sleep” was finished you could test for or set a trigger. If it was set you could send an e-mail or use the perl “system” command to start another thread that runs a batch sql script. I have done each of these things but not together. It is just a thought.

Good luck, let us know if you try it and it works.

Our thoughts are only good if they work.