Ahhh, thats very good to know. Thank you. On Wed, 2004-12-15 at 19:09 -0500, Harrison Fisk wrote: > No. > > In InnoDB an UPDATE is done as a DELETE/INSERT internally because it > is > multiversioning and it has to be able to rollback in case of a > problem. > So the UPDATE effectively does the same thing as the REPLACE that > hits > a problem. I would most likely stick with REPLACE since it is a bit > easier to understand how it is working and has less client code. > > Regards, > > Harrison -- John A. McCaskey Software Development Engineer Klir Technologies, Inc. [EMAIL PROTECTED] 206.902.2027
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]