MySQL ODBC Connector - UPDATE behavior

Author

UPDATE behavior

Nicolas Verhaeghe

2006-01-28, 11:23 am

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 archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Gleb Paharenko

2006-01-28, 11:23 am

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 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...
>

--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links