Posted by Andreas Lange on 11/11/05 19:32

Am 11.11.2005, 18:18 Uhr, schrieb ben <usenet@bens-house.org.uk>:
> When I try to run the following update, it does not work! There is no
> error, just 0 affected rows.
>
> update testupdate SET Status='Newstatus' WHERE
> SecondaryID='3321822951131719083090';

borrowed from the php manual ;-)

When using UPDATE, MySQL will not update columns where the new value is
the same as the old value. This creates the possibility that
mysql_affected_rows() may not actually equal the number of rows matched,
only the number of rows that were literally affected by the query.

Maybe this is the case here.

--
Andreas Lange

• Next in forum: Development Tools
• Prev in forum: Problem with Update, index and UTF8 (Mysql 4.1)
• Thread view: Re: Problem with Update, index and UTF8 (Mysql 4.1)

[Reply to this message]