Reprinted from:
http://blog.csdn.net/amohan/article/details/9980315
Fast and Efficient use: SET sql_safe_updates = 0; don't look at it!
When you use MySQL Workbench to perform a database management update today, a statement that executes an update encounters the following error message:
Error code:1175
You is using Safe update mode and you tried to update a table without a WHERE is uses a KEY column
After a search, I found the security settings for MySQL Workbench. This error is prompted when the SQL statement to be executed is a batch update or delete.
Here's how to fix it:
- Open the Workbench menu [edit]->[preferences ...]
- Switch to the [SQL Editor] page
- Remove the checkmark before [forbid UPDATE and DELETE statements without a WHERE clause (safe updates)]
- Click the [OK] button
- The final step is to remember to restart the workbench, or you will still get this error message.
Error code:1175 You is using Safe update mode and you tried to update a table without a WHERE that