MySQL Workbench Batch Update or delete

When using MySQL workbench for batch updates or deletions, the following error occurs:

Error code:1175. You is using Safe update mode and you tried to update a table without a WHERE is uses a KEY column to disable safe mode , toggle the option in Preferences, SQL Queries and reconnect.0.000 sec

Because it is the default security setting for MySQL Workbench, the table cannot be updated in bulk.

Workaround:

First, add before the SQL statement

SET sql_safe_updates = 0;

Second, modify the MySQL Workbench settings:

• Open the Workbench menu [edit]->[preferences ...]

• Switch to the [SQL Queries] page (different versions may be in SQL Editor)

• "Safe Updates". Forbid UPDATEs and deletes with no key in WHERE clause or no LIMIT clause. Requires a reconnection before the check is removed.

• Click "OK" to restart the workbench.

MySQL Workbench Batch Update or delete