Insert ignore into FEDERATED_TABLE select * from TABLE
Same problem exists in newest version of mysql5. The 'insert ignore' statement works to get data from a federated table to a local table but not to isnert data into the federated remote table. then the ignore part is not working. This means i can't synchronise my tables/databases unless i write scripts on both servers adn run both. i want to run batch scripts/files on only one server to put all records into both tables.
Anyone tried using an "Insert ignore into FEDERATED_TABLE select * from TABLE" statement???
Thanks much, markandeya
Subject
Views
Written By
Posted
8468
December 29, 2005 12:32AM
Insert ignore into FEDERATED_TABLE select * from TABLE
5493
June 14, 2006 04:48AM
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.