call script from mysql trigger

English Programming/Scripting
1

Hello.
Is there any way to call a script (php or perl, not important now) from a mysql trigger?.
The thing is that I need to update another database but only when a certain value is inserted and I have no control over the insertion, just permission to read and write in that mysql database.

Thanks!

2

Apparently not, according to the trigger FAQ: MySQL :: MySQL 5.0 Reference Manual :: A.5 MySQL 5.0 FAQ — Triggers

3

30.5.10: Can triggers call an external application through a UDF?

No, not at present.

>:(

Thank you ken_yap.
I’ll find another way.

4

How about TCL using a UDF:
Dossy’s Blog: tcl-mysql-udf 0.2 and Win32 DLL binary

If you want something else, I recommend Roland Bouman’s guide to get you started:
Roland Bouman’s blog: Creating MySQL UDFs with Microsoft Visual C++ Express

5

B.5.10: Can triggers call an external application through a UDF?

Yes. For example, a trigger could invoke the sys_exec() UDF available at MySQL Forge here: Projects :: lib_mysqludf_sys