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

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

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 12:02PM

If an Insert fails, there's an error message.

Have you done a test Insert in the mysql client proving the Trigger is being invoked eg by having it set a semaphore variable?

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

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

1559

Cassie Breen

March 06, 2018 03:39PM

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

566

Peter Brawley

March 06, 2018 08:55PM

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

596

C B

March 07, 2018 10:10AM

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

628

Peter Brawley

March 07, 2018 12:02PM

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

598

C B

March 07, 2018 01:47PM

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

651

Peter Brawley

March 07, 2018 03:36PM

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.