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

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.

Update Safe Mode

Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz