MySQL error code: 1175 during UPDATE in MySQL Workbench - MySQL DBA Tutorial

MySQL error code: 1175 during UPDATE in MySQL Workbench


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 is the error you get when you have "Safe update" setting enables in MySQL Workbench.

To disable, you can follow below steps

  • Go to Edit --> Preferences
  • Click "SQL Editor" tab and uncheck "Safe Updates" check box
  • Query --> Reconnect to Server // logout and then login
  • Now execute your SQL query


MySQL Workbench Tutorial - Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE