Re: UPDATE and INSERT in one

[David Precious]

lists@stripped wrote:
> I want to update a table if it meets some conditions (already exist) and 
> INSERT otherwise?
> 
> Right now I am doing it this way:
> 
> 1. SELECT the record
> 2. If it exist, I UPDATE it
> 3. If it does not exit, I INSERT a new record
> 
> Could this be done in one query? I mean like conditional update/insert?

Take a look at REPLACE:

http://dev.mysql.com/doc/refman/5.0/en/replace.html


-- 
David Precious
http://blog.preshweb.co.uk/