Re: insert/update

--- Tom Allison <tallison(at)tacocat(dot)net> wrote:
> Jeff Eckermann wrote:
> > --- Tom Allison <tallison(at)tacocat(dot)net> wrote:
> >
> >>I seemed to remember being able to do this but I
> >>can't find the docs.
> >>
> >>Can I run a sql query to insert new or update
> >>existing rows in one query?
>
> So I have to watch out for transactions on this?
> Essentially what I'm trying to do is one of the
> following two:
>
> if exists update a field to field+1 on one record
> if it doesn't exist, insert a row with field = 1
>

I'm not sure what you are asking here that is not
already covered. I suggest you spend some time
reading the documentation on concurrency, and
searching the archives for some of the lengthy past
discussions on this topic.

__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/