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
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
