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_at_g44g2000cwa.googlegroups.com>
Date: 11 Oct 2005 21:14:49 -0700
Message-ID: <1129090489.760145.305820_at_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 Wed Oct 12 2005 - 06:14:49 CEST