INSERT INTO schema.table VS use schema
I have configured replication from one DB to another on different server. It works correctly except when:
mysql -hSRVCMYSQLD1 -utestUsr -Dmysql
-- Records is added to table but is not replicated!
INSERT INTO test.animals (name) VALUES ('Dog1'),('Cat1');
mysql -hSRVMYSQLD1 -utestUsr -Dmysql
-- Records is added to table and replicated correctly.
Use test;
INSERT INTO test.animals (name) VALUES ('Dog1'),('Cat1');
Is this an error or is it working as designed?
Subject
Views
Written By
Posted
INSERT INTO schema.table VS use schema
2043
May 29, 2014 05:36PM
841
June 02, 2014 11:30AM
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.