Re: REPLACE vs INSERT/UPDATE

At 4:27 PM -0400 9/21/01, Jason Frisvold wrote: >Currently I'm checking to see if a value exists in the database before >deciding whether to update it or insert it. Would this be quicker to do if >I merely used REPLACE? Is that the purpose of the REPLACE command? If it >exists, just update it,

REPLACE vs INSERT/UPDATE

Currently I'm checking to see if a value exists in the database before deciding whether to update it or insert it. Would this be quicker to do if I merely used REPLACE? Is that the purpose of the REPLACE command? If it exists, just update it, and if it doesn't exist, insert it? Thanks, --