MySQL Lists: mysql: Re: if exists UPDATE else INSERT

List:	General Discussion	« Previous Message Next Message »
From:	Jim Faucette	Date:	October 30 1999 1:36pm
Subject:	Re: if exists UPDATE else INSERT
View as plain text

Look up REPLACE INTO in the manual. It sounds like what you need.

  jim...

Erik Andersson wrote:
> 
> Can I create a SQL command which does an UPDATE if a post exist or else does
> an INSERT?

Thread
• if exists UPDATE else INSERT	Erik Andersson	30 Oct
• Re: if exists UPDATE else INSERT	Jim Faucette	30 Oct
• Re: if exists UPDATE else INSERT	Scott Hess	1 Nov
• Re: if exists UPDATE else INSERT	Vivek Khera	1 Nov
• Re: if exists UPDATE else INSERT	Scott Hess	2 Nov