P.S. You could also UPDATE 4 first with the new value and then DELETE 2. ----- Original Message ----- From: "Rolf Hopkins" <[EMAIL PROTECTED]> To: "Artem Koutchine" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, July 01, 2001 15:03 Subject: Re: UPDATE/REPLACE command > No there isn't. You'll need to DELETE first and then UPDATE. Ie. delete 4 > first and then update 2. > > ----- Original Message ----- > From: "Artem Koutchine" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, June 29, 2001 22:43 > Subject: UPDATE/REPLACE command > > > > Hi! > > > > Was UPDATE/REPLACE command implemented? > > I mean, a command which does update and if it > > updated to record to match an already existing > > unique index then the old record is killed and the > > new stays. > > > > Example ( UPPLACE - UPDATE/REPLACE command): > > > > table: ids > > ID (primary key) NAME > > 1 a > > 2 b > > 3 c > > 4 d > > > > UPPLACE ids set id=4, name='z' where id=2; > > after this table has: > > 1 a > > 4 z > > 3 c > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php