I agree, you should just update it since the standard operation for
to only apply updates if the value is changing.
"If you set a column to the value it currently has,
MySQL notices this and does not update it."
From: Peter [mailto:peterpub1@stripped]
Sent: Saturday, December 09, 2006 3:42 PM
To: Nick Meyer
Subject: Re: only update if values different
with good indeces 100 000 rows is basically nothing.
Give it a try.
Nick Meyer wrote:
> What is the best way to UPDATE a row only if values are different? We
> have a mainframe extract that literally has 100,000 rows and am
> about the performance of just running INSERTs each night.
> Is there a simple comparison command or would you have to nest a
> statement? Thank you,
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql