Hi all,
Actually my aim is to call the shell script when ever there is a hit in a mysql table which consist of 3 values. Acter some research I came to know that it is not possible and can achive with timestamp. Can someone please tell me how to read the table timestamp which should done automatically. Also it got to read value from the table to do the process. Can some one please suggest me solution for this.
Thanks in Adavance,
Santhoshvkumar
Well, to call a shell from a RDBMS engine is tricky, as it runs under the DB id, so be careful.
Maybe you should share the context with us. A hit on a table is a select of any row. If the table is really a view of a sp, the sp can call a udf to do anything you can write, once either for each row or for the whole select. So, you could log to track id's selecting each row or anywhere in the table.
Hi DGPickett,
Yeah.. here I share the table which I have
Table : role_tbl
ID | Name | Role
1 san manager
2 bec manager
So, this table get from a web application according to the selection on admin each time... it should call the shell program. Here is my scenario.
My shell script got to recive the values from the table when ever there is a hit in a table which got to fetch data from table where my shell got to receive the code and do a file save option. Kindly suggest me a method to achive it.
With Regards,
santhoshvkumar
Rename the table, placing a view under that name that calls a stored procedure that calls a UDF that calls the script. Do you care which rows are selected when it is triggered? Where is this passed code coming from?