OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: Update Syntax

From: Darryle Steplight (dsteplightgmail.com)
Date: Sun Jul 26 2009 - 12:18:58 CDT

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<victorsubervigmail.com> 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?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql