mysql 1175 error resolution

1175 error when using update query in mysql workbench. This is because the safe mode is set by default in the update query.

Error contents

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

Run the query statement below and then run it to solve the problem.

SET SQL_SAFE_UPDATES = 0;

If you turn on the workbench again or open a new sql document, you have to do SQL_SAFE_UPDATES again. To do it permanently, you can set options on the workbench menu.