From: Date: December 28 2005 4:47pm
Subject: Re: update or insert if necessary?
List-Archive: http://lists.mysql.com/mysql/193282
Message-Id: <000b01c60bc5$f30c72e0$34ef4544@milesteg>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit

Actually, you may be more interested in:

INSERT . ON DUPLICATE KEY UPDATE

----- Original Message ----- 
From: "steve" <networks1@stripped>
To: <mysql@stripped>
Sent: Wednesday, December 28, 2005 6:57 AM
Subject: update or insert if necessary?


I have a situation where I need to update a record for a given key in a 
MySQL table, but insert a record if the key doesn't exist.  I could do this 
by doing a SELECT on the key, then doing an UPDATE if anything comes back, 
or and INSERT otherwise.  This seems rather clunky though, and I'm wondering 
if there is anything like and "up-sert" command, or at least a preferred way 
of doing this operation.

TIA....Steve