MYSQL:Error Code:1175

Geeks, please accept the hero post of 2021 Microsoft x Intel hacking contest>>>

Using the official MySQL workbench, when you update, delete, and truncate (especially when there is no primary key), you will be prompted:

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. 0.000 sec

can be modified through the following figure . After the modification, please restart the workbench

or by adding set SQL before executing the script_ SAFE_ UPDATES = 0; Release security mode

Similar Posts: