Error code:1175 occurs when Update/delete operation is performed in MySQL

The problem is personal record, you are free to spray.

When an update operation is performed on one of the MySQL tables, it is found to be unable to operate and the following error occurs.

On the

For this issue,

Cause: MySQL security mechanism, the default is not allow arbitrary data erasure.

WORKAROUND: Reduce the security mechanism, execute the following statement can set sql_safe_updates = 0;

The UPDATE statement can be executed successfully

Error code:1175 occurs when Update/delete operation is performed in MySQL