MySQL Forums
Forum List  »  Triggers

Re: Can triggers call SYSTEM?
Posted by: Marco Retamales
Date: April 14, 2009 03:34PM

Hello,

This is my example. It's right!

Please, use mysql shell on linux command line (On Windows throw an syntax error):

DELIMITER $$
CREATE TRIGGER tg1 AFTER INSERT ON `your_table`
FOR EACH ROW
BEGIN
\! echo "php algun_script_php.php" >> /log/yourlog.txt
END $$
DELIMITER ;

Please, check rigth permissions for write the file yourlog.txt.

Regards!

Marco

Options: ReplyQuote


Subject
Views
Written By
Posted
17540
September 03, 2007 01:58AM
10014
November 27, 2008 04:17PM
8879
November 28, 2008 05:14AM
Re: Can triggers call SYSTEM?
25503
April 14, 2009 03:34PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.