MySQL Execute update error: Error Code 1175 [How to Solve]

When using Mysql to execute update, if the primary key is not used in the where condition, the following error will be reported and the update cannot be executed.

Exception content: error code: 1175 You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Queries and reconnect.

Solution:
This is because MySql is running in safe-updates mode. Modify the database security mode to allow update or delete commands to be executed under non-primary key conditions.

Excuting an order:

SET SQL_SAFE_UPDATES = 0;

Similar Posts: