triggers

[FengShui1998]

Hello,

I have MYSQL on a Windows server and I'd like to send an email to a user when a new row is created that has a certain value. Can anyone help? Are there commands that will also trigger a vbscript procedure?

thanks ahead,
fengshui1998

 

[TonyGroves]

Triggers have not yet been introduced into production MySQL, but they are coming, in version 5, which is currently beta. However, they can only be used to execute certain SQL statements, so executing external scripts will not be supported.

The only way I can think of to achieve what you're looking for is to write a script which would run every so often, examining the database, and taking whatever action is appropriate.

 

[FengShui1998]

Thanks for all your help!