?
Solved

making a trigger in mysql fire a shell command

Posted on 2008-10-18
5
Medium Priority
?
1,435 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 2000 total points
ID: 22767040
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

752 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