affected rows and found rows

[Ivano Luberti <luberti@xxxxxxxxxxxx>]

Hi. i'm new to mysql and for now i'm only studying the manual.
Studying the paragraph of the myODBC driver i've found the following phrase:

"The client can't handle that MySQL returns the true value of aected rows.
If this ag is set then MySQL returns 'found rows' instead."


Then in the section on C API for mySQL i found in the option section:

return-found-rows, tell mysql_info() to return found rows instead of 
updated rows when using UPDATE.

I would know in what cases "found rows" and "updated rows" could be 
different: what i think is that if i get no error code the two number would 
be the same, but if the update fails (example key violation) the two number 
would be different.

i'm rigth ?



==================================================
dott. Ivano Mario Luberti
Archimede Informatica societa' cooperativa a r. l.
Via G. Ferraris 12 - 56121- Ospedaletto- Pisa
tel.: +39-050-3132300
fax: +39-050-3132301
e-mail: luberti@xxxxxxxxxxxx
web: http://www.archicoop.it




---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread92318@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php