"Jayme Jeffman Filho" <[EMAIL PROTECTED]> wrote:
> I've got an unespected behavior using MySQL server-version 3.23.52 with PHP
> 4.3.0 (Apache/1.3.27 (Win32) PHP/4.3.0 running... ), if I submit an update
> query that do not modify any value on the target record the query does not
> return any row affected, while the same query executed in a C++ program
> returns 1 row affected.
>
> Is there any reason or before action check made by PHP to avoid the
> execution of no change queries ?
>
If you change column to the value that column has, MySQL doesn't update it:
http://www.mysql.com/doc/en/UPDATE.html
If you specify CLIENT_FOUND_ROWS flag, mysql_affected_rows() returns number of rows
matched by WHERE cluase:
http://www.mysql.com/doc/en/mysql_affected_rows.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ 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/[EMAIL PROTECTED]
