note 124119 added to function.mysql-affected-rows

Note that when the CLIENT_FOUND_ROWS connection flag was used, affected_rows returns the number of rows matched by the WHERE condition of an UPDATE query, even if the query doesn't actually change those rows. I.e. for INSERT INTO t(id, val) VALUES (1, 'x'); UPDATE t SET val = 'x' WHERE id = 1; the number of affected rows will be 0 normally but 1 with CLIENT_FOUND_ROWS. ---- Server IP: 208.43.231.9 Probable Submitter: 185.85.3.168 (proxied: 2001:6b0:5:1959:f0b7:82f9:a463:331e) ---- Manual Page -- http://php.net/manual/en/function.mysql-affected-rows.php Edit -- https://master.php.net/note/edit/124119 Del: integrated -- https://master.php.net/note/delete/124119/integrated Del: useless -- https://master.php.net/note/delete/124119/useless Del: bad code -- https://master.php.net/note/delete/124119/bad+code Del: spam -- https://master.php.net/note/delete/124119/spam Del: non-english -- https://master.php.net/note/delete/124119/non-english Del: in docs -- https://master.php.net/note/delete/124119/in+docs Del: other reasons-- https://master.php.net/note/delete/124119 Reject -- https://master.php.net/note/reject/124119 Search -- https://master.php.net/manage/user-notes.php