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

--- [EMAIL PROTECTED] wrote: > 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 TA

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

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 VAL

[sqlite] UPDATE OR REPLACE same as UPDATE?

Is UPDATE OR REPLACE always equivalent to just UPDATE? Food fight? Enjoy some healthy debate in the Yahoo! Answers Food & Drink Q&A. http://answers.yahoo.com/dir/?link=list&sid=396545367 -