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

  • 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

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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