List:General Discussion« Previous MessageNext Message »
From:Darryle Steplight Date:July 26 2009 5:18pm
Subject:Re: Update Syntax
View as plain text  
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