显示mysql中已经存在的数据库,当查询中传递的数据与数据库中已经存在的数据相同时，如何确定MySQL更新查询是否成功？...

Let's say you have a form with pre-populated data from your database, and you allow your users to make changes and save the form. If the user clicks the save button without making any changes, MySQL will not actually perform a write operation, and therefore the affected_rows will return 0.

I understand the behavior, but what is the best practice for determining if an update failed, other than checking for the number of affected_rows?

What is the best practice for differentiating between an update that actually failed, and one that "succeeded" but resulted in 0 affected_rows so that I can provide feedback to the user?

解决方案

Just check if no errors occurred after execution of query.

If you use mysql, check mysql_error():

if (!mysql_error()) print 'all is fine';

Same for mysqli.