MySQL Forums
Forum List  »  Replication

INSERT INTO schema.table VS use schema
Posted by: Rudy Hernandez
Date: May 29, 2014 05:36PM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
INSERT INTO schema.table VS use schema
2043
May 29, 2014 05:36PM


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.