--Original Message-
From: Peter [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 09, 2006 3:42 PM
To: Nick Meyer
Cc: mysql@lists.mysql.com
Subject: Re: only update if values different
Hello,
with good indeces 100 000 rows is basically nothing.
Give it a try.
Peter
Nick Meyer wrote:
> Wha
Hello,
with good indeces 100 000 rows is basically nothing.
Give it a try.
Peter
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 worried
> about the performance of just running INSERTs ea
On 09/12/06, Nick Meyer <[EMAIL PROTECTED]> 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 worried
about the performance of just running INSERTs each night.
Is there a simple comparison command or would