Solved

making a trigger in mysql fire a shell command

Posted on 2008-10-18
5
1,424 Views
Last Modified: 2008-11-21
Hi,

I would like to have a trigger execute a shell command (like "php myscript.php") when some record is modified.
0
Comment
Question by:siranm
5 Comments
 
LVL 1

Expert Comment

by:hakkekushou
ID: 22751210
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
 
LVL 3

Author Comment

by:siranm
ID: 22752310
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
 
LVL 22

Accepted Solution

by:
earth man2 earned 500 total points
ID: 22767040
0

Featured Post

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question