Call an external program from MySQL trigger

Call an external program from MySQL trigger

MySQL provides a way to implement your own functions, its called User Defined Functions (UDF)

sys_eval - executes an arbitrary command, and returns it's output.
sys_exec - executes an arbitrary command, and returns it's exit code.
sys_get - gets the value of an environment variable.
sys_set - create an environment variable, or update the value of an existing environment variable.

http://www.mysqludf.org/

https://github.com/mysqludf

http://dev.mysql.com/doc/refman/5.0/en/adding-udf.html