MySQL Forums
Forum List  »  Triggers

Re: Creating trigger to monitor read-only table at another DB
Posted by: Peter Brawley
Date: August 19, 2017 10:05AM

A Trigger must be created on the server where its target table is.

If your access to the remote server is read-only, your best bet might be to regularly poll information_schema on the remote server for the last change to the target table.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Creating trigger to monitor read-only table at another DB
190
August 19, 2017 10:05AM


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.