Re: update query returns wrong number of rows affected

Dave Dyer wrote:

> For some UPDATE queries (possibly those involving joins?), the number of
> rows reported for the query is the number of rows processed, rather than the
> number of rows actually changed.

What does the distinction between "affected" and "matched" mean? Is it, 
that some rows already had the new value? If so, I would think that I 
would indeed want to see the value "matched", because the typical use 
case is I can see is comparing the number of rows against 0.


Jochen


-- 
http://lilypie.com/baby1/050423/1/5/1/+1

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]