Re: Update vs. replace in Workbench?
Load Data doesn't have such an option. Don't know how NaviCat works around that, and it's not open source.
A possibility would be to script it such that it inserts to a temp table then does Insert Ignore or Insert On Duplicate Key to the target table---but that convenience would lose the Load Data speed advantage.
IOW I think there's not a possibility of bulk-speed updates.
Edited 1 time(s). Last edit at 03/08/2021 02:48PM by Peter Brawley.
Subject
Views
Written By
Posted
715
March 08, 2021 02:23PM
Re: Update vs. replace in Workbench?
465
March 08, 2021 02:48PM
299
March 08, 2021 03:34PM
335
March 08, 2021 03:56PM
355
March 08, 2021 04:07PM
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.