MySQL BUG: Error code:1175. You is using Safe update mode and you tried to update a table ...

A MySQL error was encountered today:

1175 Update  and  to Update Table WHERE KEY column  to option inch  -  and reconnect.

On the internet, it turned out to be set Sql_safe_updates to 1.

Workaround:

Perform

SET = 0;

Once executed, there is no problem with the SQL statement operation.

It's best to change it when it's finished:

SET = 1;

Because sql_safe_updates can prevent unsafe SQL execution, such as the following SQL

Delete  from Table /* */; Update set col='SS'/** *

If the above two procedures are executed, it is estimated that the pack is gone.

MySQL BUG: Error code:1175. You is using Safe update mode and you tried to update a table ...