MySQL Workbench: Error Code: 1175 [How to Solve]

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 Editor and reconnect.

Error code: 1175. You are using secure update mode, and you try to update a table that uses key columns without where. To disable safe mode, in preferences – & gt; Switch this option in the SQL editor and reconnect.

Solution: it can be solved with one statement.


After executing the statement, execute the update operation again.

Read More: