You are using safe update mode and you tried to update a t

Little scum · Posted on 5/22/2018 10:32:45 AM

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.

When using MySQL to execute update, if you do not use the primary key as the where statement, the above error will be reported.

This is because MySql runs in safe-updates mode, which will cause the update or delete command to not be executed under non-primary key conditions.

Execute the command SET SQL_SAFE_UPDATES = 0; Modify the database schema

If you want to improve the security level of the database, you can restore the original settings and execute the command: SET SQL_SAFE_UPDATES = 1;

Login is visible.

Little scum · Posted on 6/24/2023 1:16:12 PM

You are using safe update mode and you tried to update a t
https://www.itsvse.com/thread-4787-1-1.html

Error Code: 1175. You are using safe update mode and you tried to update a ta...
https://www.itsvse.com/thread-4051-1-1.html

Error Code: 1175. You are using safe update mode and you tried to update a ta...
https://www.itsvse.com/thread-3839-1-1.html

Error Code: 1175. You are using safe update mode and you tried to update a ta...
https://www.itsvse.com/thread-3713-1-1.html

[Source] You are using safe update mode and you tried to update a t

Related Posts

Sections viewed