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
