MYSQL WORKBENCH ERROR CODE: 1175. YOU ARE USING SAFE UPDATE MODE AND YOU TRIED TO UPDATE

created at 12-29-2021 views: 12

error

MySQL Workbench 6.3 is newly installed on Win7 computer. After opening, execute an update statement, always prompt the following error:

Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
To disable safe mode, toggle the option in
Preferences -> SQL Editor and reconnect.

solution

The error message mentioned a sentence To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect. I installed this sentence in English and searched it in the menu, and found the following solution:

Menu item Edit Preferences → select the SQL Editor on the left → uncheck the box Safe Updates' Forbid UPDATEs and DELETEs with no key in WHERE clause or no LIMIT clause. Requires a reconnection

The revised interface is as follows:

solution

created at:12-29-2021
edited at: 12-29-2021: