Select Page

When running a query within MySQL Workbench, you might see an error like this:

Error Code: 1175. You are using safe update mode…

To get around this issue, you can add this line to your query (untested):

set SQL_SAFE_UPDATES = 0;

Or, since you are using Workbench, you can turn off the option going to Edit >> Preferences >> SQL Queries >> Forbid safe updates.  Note, this setting has changed location from version to version.  In this case, I am using Workbench 6.0.