I do not know enough about the subject to answer this, but I know the folks that read this do.
From: http://mysql.meetup.com/137/boards/view/viewthread?thread=2280640
Hi,
I wonder is there any way to call an application which resides on the database server computer from stored procedure or trigger? Is the language of stored procedures and triggers only restricted by SQL statements and some arithmetic operations?
It is interesting that Oracle and MS SQL Server already have this functionality. In Oracle it is Java stored procedure, in MS SQL Server it is called "extended stored procedure" where you can call C++ routine out of your stored procedure. It is difficult overestimate the convenience of being able to do some processing triggerted by the record insertion event.
In this case the database could be used not only for "pulling" data out, but also being able to "push" data to some component.
You can go to the meetup message boards and post an answer. If you'd like to post anonymously, feel free to use the account:
admin@sheeri.net
and password
guest
Thanx!
You might also find these
You might also find these examples of UDFs interesting:
http://jan.kneschke.de/projects/mysql/udf/
(see: my mysql server sends mail)
See, I thought of that,
See, I thought of that, because it's just a C program, and you can do whatever you want there. :) Nice to know for sure, instead of saying, "I think that maybe you might want...."
It's possible, but not
It's possible, but not natively. You can do so by creating a UDF. The black magic is then encoded inside the UDF.
Examples:
MySQL Messaging: http://forge.mysql.com/projects/view.php?id=2
Jave in MySQL: http://cvs.tangent.org/myjava
Perl from MySQL:http://cvs.tangent.org/myperl