Re: How to update a table in another database based on an update/insert to a table?

[Peter Brawley]

It's just standard programming/debugging. Add a line of code to the Trigger that says, eg ...

set @mytrigfired=true;

... then after executing the Insert cmd in the mysql client, inspect the semaphore with ...

select @mytrigfired;

The mysql client will show any error msg that arises from the Insert.

(Always test sql in a test bed using a program like the mysql client program before running the sql against live data.)