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

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: