Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Do we always have to update or insert? Why can't we just relate?

Re: Do we always have to update or insert? Why can't we just relate?

From: Marshall Spight <marshall.spight_at_gmail.com>
Date: 11 Oct 2005 21:14:49 -0700
Message-ID: <1129090489.760145.305820@g44g2000cwa.googlegroups.com> 





Troels Arvin wrote:


> On Mon, 10 Oct 2005 16:43:18 -0700, arthernan wrote:

> >                   Update .... set .. where ...

> >                   If (no update was done) then

> >                      Insert .....

> >                   end if

>

> The operation you describe is sometimes informally called "upsert".




The problem with the term "upsert" and its converse, "indate",
is that they both sound like terms that you'd find in the
seedier parts of the internet.



MySQL calls this "insert or update". I call it "put".




Marshall
Received on Tue Oct 11 2005 - 23:14:49 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US