I am trying a scenario for calling a shell script when ever a trigger is called. Can some one guide me how to achive this scenario. Also it should passes the value from the table to the shell script. Can some one explain me along with the example.
I actually got an database which consist of 3 column the things it will get the data from a web application and I need to read the column that last affected in the database. and I need to read it through a shell or any program and need to store it in a file system. inorder for some other computation. I developed a code with shell script to do this process. Also I called with mysql >! someshell.sh its working fine. but when ever there is a update in table how to achive it. Please help me with this.