MySQL Forums
Forum List  »  Triggers

Re: How to update a table in another database based on an update/insert to a table?
Posted by: Peter Brawley
Date: March 07, 2018 03:36PM

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.)

Options: ReplyQuote

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.