Re: Insert Ignore / On Duplicate Key - Conversion
Posted by:
Jim Taylor
Date: February 25, 2012 08:49AM
Thank you. I will have to take a closer look at this one. At first glance, in some cases it would work, if I am populating the entire record or don't care about any other data, but one downside is that I would lose any other data in the record if I am only inserting a few of the fields.
Had forgotten about this function or maybe I had dismissed it for the reasons above. I am guessing there aren't any other options apart from doing the insert and then retrieving all the data in an additional select and then doing an update...a bit unwieldy but life is like that sometimes :-)
Thanks again.
Jim
Subject
Views
Written By
Posted
6169
February 24, 2012 12:11PM
3105
February 25, 2012 03:22AM
Re: Insert Ignore / On Duplicate Key - Conversion
3184
February 25, 2012 08:49AM
3425
February 25, 2012 10:08AM
2859
February 25, 2012 04:34AM
2978
February 25, 2012 02:57PM
2652
February 25, 2012 04:27PM
2759
February 28, 2012 01:17AM
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.