ignore in insert ignore not working
dear friends,
i can run the command insert ignore into calls select * from fedcalls;
This fetches rows from the remote server and inserts then into the local database while ignoring any duplicate entry errors caused by the primary key field.
i can not run the command in the reverse direction i.e. insert ignore into fedcalls select * from calls; without getting the duplicate error message and the query halting.
it works this way from Linux to Windows and visa versa.
anyone run into this or know about it? Should we tell the Mysql developers?
Have a very happy new year with many good and new and strong connections.
Subject
Views
Written By
Posted
ignore in insert ignore not working
8504
December 29, 2005 12:32AM
5508
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.