Triggers / Events

[areric]

Hey everyone,

I was wondering is anyone knew how i can set up some sort of job or trigger based on an event that occurs in my db.

Basically i have a db that takes periodic entrys. I want to make a script that will fire off an email to a list of people whenever an entry is made. I could write a cron job to run a php script that emails those people every hour or so but thats timeed and inefficnet. I really need something that will just do it whenever a new entry comes in.


Thanks

 

[sleipnir214]

Triggers are planned for implementation in MySQL 5.1.

You're either going to have to use your cron job idea or add logic to your apps to perform the action.



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[Bastien]

Why not add a mail script to whatever interface your db uses..if php you can use mail to send emails from the application...

Triggers and SPs are coming with v5 of mySQL, still in alpha release

Bastien

Any one have a techie job in Toronto, I need to work...being laid off sucks!