MySQL Forums
Forum List  »  Knowledge Base

Replication btw 2 tables in same database.
Posted by: Pratik Singh
Date: September 22, 2009 02:26AM

Hello Guys ,

I have one odd kind of requirement. I need to copy some kind of data from table1 to table2 , I was using trigger earlier but that kills the DB.

is that possible if I can use replication btw 2 tables in same database. like what event insert/update/delete happened on table1 , that should replicate on table2 .. if that is possible then no need to use big trigger finally to copy the data from one table to other table...

in other tear I would say table1 is subset of table2 .. so what ever happen in table1 , should replicate on table2

would be great ,if there is other solution is possible to copy the data from table1 to table2 at the end process ( except trigger)

Please do let me know if my requirement is not enough clear ...

Thanks in advance !

Options: ReplyQuote


Subject
Views
Written By
Posted
Replication btw 2 tables in same database.
2381
September 22, 2009 02:26AM


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.