When performing UPDATE and DELETE operations in Mysql, an error number 1175 occurs because the safe mode is not enabled. The solution is as follows:
SET SQL_SAFE_UPDATES = 0;
After performing UPDATE and DELETE operations, it is recommended to reopen the safe mode:
SET SQL_SAFE_UPDATES = 1;
What is safe mode:
A mode in which UPDATE or DELETE commands cannot be executed under non-primary key conditions.
The security mode query can be performed by the following statement:
SHOW VARIABLES LIKE 'SQL_SAFE_UPDATES';