MySQL Forums
Forum List  »  Triggers

Re: Can triggers call SYSTEM?
Posted by: Miroslav Kubiczek
Date: November 27, 2008 04:17PM

You can use '\!' instead of 'system'. Should work in triggers and SPs.

Example:

CREATE TRIGGER tg1 BEFORE UPDATE ON alarms
FOR EACH ROW
BEGIN
\! echo "I am message from a system call.";
END $$

Options: ReplyQuote


Subject
Views
Written By
Posted
17548
September 03, 2007 01:58AM
Re: Can triggers call SYSTEM?
10020
November 27, 2008 04:17PM
8885
November 28, 2008 05:14AM
25545
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.