ERROR code:1175 you ARE USING SAFE UPDATE MODE an_mysql

Fast and Efficient use: SET sql_safe_updates = 0; don't look at the bottom!

When using MySQL Workbench for database management updates today, the following error message is encountered when executing an updated statement:

Copy Code code as follows:

Error code:1175
You are using Safe update mode and your tried to update a table without a WHERE that uses a KEY column

After a search to find the original MySQL Workbench security settings. This error is prompted when the SQL statement to execute is batch-updated or deleted.

The workaround is as follows:

1. Open the Workbench menu [edit]->[preferences ...]
2. Switch to [SQL Editor] Page
3. Remove the hook before [forbid UPDATE and DELETE statements without a WHERE clause (safe updates)]
4. Click the [OK] button
5. The final step remember to restart the workbench, otherwise you will still get this error hint.

The following figure:

Running the SQL statement again is no problem.