UPDATE behavior

2006-01-28 Thread Nicolas Verhaeghe
Is it normal for MySQL to not update fields that are already identical? I am talking about an INNER JOIN UPDATE, when copying from table A over table B. My count did not match at the first run and when I did the second run, I go a zero rows updated... -- MySQL General Mailing List For list

Re: UPDATE behavior

2006-01-28 Thread Gleb Paharenko
Hello. If you set a column to the value it currently has, MySQL notices this and does not update it. Perhaps it is the answer on your question. See: http://dev.mysql.com/doc/refman/5.0/en/update.html Nicolas Verhaeghe wrote: Is it normal for MySQL to not update fields that are already