This is a very common error facing by MySQL Database Developer.
Error Code:1175 You are using safe update mode. This means that you can’t update or delete records without specifying a key (Primary key) in the WHERE clause.
This option is by default ON and if you want to update your records without specifying a key in WHERE clause, you can disable this option at session level or disable for MySQL workbench.
You can use below script to disable this option at session level.
SET SQL_SAFE_UPDATES = 0;
Use below steps to uncheck safe update check box.
- Go to Edit -> Preferences.
- Go to SQL Editor tab.
- Uncheck “Safe update” check box.
- Reconnect to your server.
- Do not require to restart MySQL Services.