Error Code: 1175

When updating a table using mysql workbench, the following exception is reported:

Error Code: 1175. To disable safe mode, toggle the option in Preferences-> SQL Editor-> Query Editor and reconnect.

You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column

When using the secure update mode, the update statement must use a keyword column attribute to limit the update range. If you do not use a keyword column to limit the range or update all records, you cannot use the security update mode.

The solution is to run the following statement to set the update mode to non-secure.

SET SQL _SAFE_UPDATES = 0;