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: UPD
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 comman
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
