From: Dan Nelson
Date: July 9 2009 2:11am
Subject: Re: Another Trigger Question!
List-Archive: http://lists.mysql.com/mysql/218087
Message-Id: <20090709021154.GA63413@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Jul 09), Marcel Grandemange said:
> Create Trigger hostchange
> BEFORE UPDATE ON host
> FOR EACH ROW
> BEGIN
> IF NEW.status != OLD.status THEN
> use smsgw;
> insert into outbox (number, insertdate, text, phone, dreport) VALUES
> ('0836075144', '', 'HostDown', '1', '1')");
> END IF;
> END;
> 
> I have my idea of a trigger above that for obvious reasons wont work ,
> however describes what im trying to do best!
> 
> Im monitoring a value status and if it changes id like to insert a record
> into a entirely separate table in a separate DB.

insert into smsgw.outbox [...]
 
-- 
	Dan Nelson
	dnelson@stripped