List:General Discussion« Previous MessageNext Message »
From:Victor Subervi Date:July 26 2009 5:47pm
Subject:Re: Update Syntax
View as plain text  
Perfect. Thank you.
Victor

On Sun, Jul 26, 2009 at 2:18 PM, Darryle Steplight <dsteplight@stripped>wrote:

> Hi Vicor,
>    Look into INSERT ON DUPLICATE or REPLACE statements. You need to
> have a primary key or unique key for these too work.
>
> On Sun, Jul 26, 2009 at 1:11 PM, Victor Subervi<victorsubervi@stripped>
> wrote:
> > Hi;
> > I would like to test the following:
> >
> > update maps set map where site=mysite;
> >
> > to see if there is such an entry in maps. If there is, then update. If
> there
> > is not, then I would like to execute an insert statement. How do I do
> that?
> > TIA,
> > Victor
> >
>
>
>
> --
> A: It reverses the normal flow of conversation.
> Q: What's wrong with top-posting?
> A: Top-posting.
> Q: What's the biggest scourge on plain text email discussions?
>

Thread
Update SyntaxVictor Subervi26 Jul
  • Re: Update SyntaxMichael Dykman26 Jul
  • Re: Update SyntaxDarryle Steplight26 Jul
    • Re: Update SyntaxVictor Subervi26 Jul