only update if values different

[Nick Meyer]

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 you have to nest a SELECT 
statement? Thank you,

Nick


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]