MySQL Forums
Forum List  »  Federated Storage Engine

Insert ignore into FEDERATED_TABLE select * from TABLE
Posted by: markandeya chasan
Date: June 14, 2006 04:48AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
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.