且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

mySQL UPDATE 查询返回“0 行受影响";

更新时间:2022-05-02 22:47:14

按照安非他明和雅达的建议,使用 SELECT 检查您的电话号码是否在表格中.

As amphetamine and Yada suggested, check with a SELECT, if your phone number is in the table.

但请记住:如果相关行的 调用 的值已经是是",mysql 不会更改该值,因此将返回0 行受影响".所以一定要检查 called

But keep in mind: If the value for called of the row in question is already "Yes", mysql won't change the value and will therefore return "0 rows affected". So be sure to also check the current value of called