Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Is it possible to setup some kind of smart replication, so that these columns are automatically updated if they are changed in another database ..

Like : rows are automatiically added, some columns are automatically synced, but other columns are not

share|improve this question
    
Let's say you have a four-column table. You want (for example) to sync only two of them. Is this what you want? –  Khaled Nov 23 '10 at 7:47

1 Answer 1

Do you want to perform an action on the same database server rather than a remote DB? If so, the device you want are triggers: http://dev.mysql.com/doc/refman/5.0/en/triggers.html

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.