RE: only update if values different

2006-12-11 Thread emierzwa
--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

Re: only update if values different

2006-12-09 Thread Peter
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

Re: only update if values different

2006-12-09 Thread Dotan Cohen
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