Re: [sqlite] UPDATE OR REPLACE same as UPDATE?

[drh]

Joe Wilson <[EMAIL PROTECTED]> wrote:
> Is UPDATE OR REPLACE always equivalent to just UPDATE?
> 

No.  UPDATE is the same as UPDATE OR ABORT.  Try replacing
the UPDATE OR REPLACE in the following script with just
UPDATE to see the difference:

   CREATE TABLE t1(x UNIQUE, y);
   INSERT INTO t1 VALUES(1,2);
   INSERT INTO t1 VALUES(3,4);
   
   UPDATE OR REPLACE t1 SET x=3 WHERE y=2;
   SELECT * FROM t1;
   
--
D. Richard Hipp  <[EMAIL PROTECTED]>


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------