Paul DuBois schreef:

> UPDATE tbl_name SET col_name = 0 WHERE col_name = 0;
>
> If you've selected the rows-changed count, $sth->rows() will always
> return 0, because the statement doesn't actually change any col_name
> value from its current value.

That would be an odd optimization. The update should take place, even if
the value wouldn't seem to change anything. Hidden fields like "record
last updated", or triggers, could depend on this.

-- 
Affijn, Ruud

"Gewoon is een tijger."

Reply via email to