PHP / MySQL: updating a nonexistent column value

Question

So this query:

mysql_query("UPDATE item SET name = 'foo' WHERE name = 'bar'");

returns 1, but the value "bar" does not exist in the table. As expected, nothing has changed in the database itself, but should mysql_query () not return 0 in this case?

Answer 1

It returns truebecause the request was successful. If you want to know how many rows have been updated, you should use mysql_affected_rows.

Answer 2

If you simply echo the mysql_query value, it will be true or false. You need to use mysql_affected_rows()to get the actual rows affected.

Answer 3

, . , .. . - .