• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1437
  • Last Modified:

making a trigger in mysql fire a shell command

Hi,

I would like to have a trigger execute a shell command (like "php myscript.php") when some record is modified.
0
siranm
Asked:
siranm
1 Solution
 
hakkekushouCommented:
It cannot be done unless you are using the mysql command line client where you would just use \! before the command however that is only a feature of the command line client and not the server. MySQL developers state that it will be some time until they add that feature de to the mass amounts of platforms they support.
0
 
siranmAuthor Commented:
I was able to do it on PostgreSQL.... I had to write the trigger in C languge...

Can I write triggers in C language in MySql ?
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now