Mysql Update Issue with SET SQL_SAFE_UPDATES=0;

Question

I am having Serious Issue with my Mysql 5.7.6 .When I try to update my simple table .Can any one find my issue for update below table . When I got SQL_SAFE_UPDATES related problem then I have follow all step of STACK_OVERFLOW_LINK but here issue is some thing different

We can have loop on log also The line wants to tell different

 11:10:19   UPDATE `mydb`.`dailyreport` SET `outTime`="19:42:51" WHERE `idDailyReport`='50468'  0 row(s) affected
     Rows matched: 1  Changed: 0  Warnings: 0   0.375 sec

Why my outTime field is not updateing ??

try by restarting the server or reconnecting to it, because no problem seems in your query — Sanket, Jun 22 '17 at 04:45
for reference https://stackoverflow.com/questions/11448068/mysql-error-code-1175-during-update-in-mysql-workbench — Sanket, Jun 22 '17 at 04:46

score -1 · Answer 1 · answered Jun 21 '17 at 06:01

-1

IT has SHOWN that Rows matched: 1 AND Changed: 0 Because you are updating the same value twice i.e. you are not changing the value of the row hence it is showing Changed: 0

try to update again with different values

answered Jun 21 '17 at 06:01

karan yadav

59
1
6

can you please if my update successfully run and then I select that rows what should be the result set value ??? – Suraj Khanra Jun 21 '17 at 06:07

Mysql Update Issue with SET SQL_SAFE_UPDATES=0;

1 Answers1