Possible to call a shell script within a mysql query?
we have a rather odd request from our employer, which led us to the jobs to somehow make it possible to call a shell script from within a mysql query.
We want to have a mysql query executed on a schedulded base. Which is possible through the included scheduler in mysqld. The tricky part is after this query is done, we like to have shell script to be executed.
Is this possible, and if how can this be done.
Any, realy any input on this is very appreciated.