In the last episode (Jul 09), Marcel Grandemange said:
> Create Trigger hostchange
> BEFORE UPDATE ON host
> FOR EACH ROW
> IF NEW.status != OLD.status THEN
> use smsgw;
> insert into outbox (number, insertdate, text, phone, dreport) VALUES
> ('0836075144', '', 'HostDown', '1', '1')");
> END IF;
> 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 [...]