Close Workbench’s Safe Update Mode

Workbench is the free visualization database operation software provided by the mysql official, which is often used by developers to connect to the database and execute the SQL code. I met “safe update mode” error recently, here is one way to solve this problem.

X8FD8OEMI2GXS8EZVK - Close Workbench's Safe Update Mode

First, we look the error code.

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 Queries and reconnect.

It means safe mode has been enabled and it will not allow us to make any changes in the table, thus first of all we should make changes to disable the safe update mode.

Here is effective code.

QR90W2YCUC9GW0ZR26 - Close Workbench's Safe Update Mode

After executing this line of command code in workbench, we find that the statements of UPDATE and DELETE can be executed normally.

此条目发表在DB, MySQL分类目录,贴了, , , , , 标签。将固定链接加入收藏夹。