Error code:1175 You is using Safe update mode and you tried to update a table without a WHERE that

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