MySQL Forums
Forum List  »  Triggers

Advanced Search
New Topic

Creating trigger to monitor read-only table at another DB
Posted by: Cin Lung Chen
Date: August 19, 2017 12:48AM

Dear Experts

I need to be able to monitor any new entries from a table at another database server so that if a new record is inserted into that table, I will be able to get that new record automatically to my own table.

The reason is because I am only given read only access to the other database table. I cannot create trigger at the other database server. I have to create some-sort of trigger at my own database server to monitor and copy any new data from the table at the other server.

can anyone help?

Thank you

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Creating trigger to monitor read-only table at another DB
1250
Cin Lung Chen
August 19, 2017 12:48AM
Re: Creating trigger to monitor read-only table at another DB
638
Peter Brawley
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.