MySQL: Error Code-1175 You are using safe update mode

This is a very common error facing by MySQL Database Developer.
Error Code:1175 You are using safe update mode.
That 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 disabled for MySQL workbench.

You can use below script to disable this option at session level.

1	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.