Error Code: 1175. You are using safe update mode and you tried to update a ta...

Little scum · Posted on 5/22/2017 11:13:21 AM

11:08:09 update user set host='%' where user='root' 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. 0.000 sec

This is because MySql runs in safe-updates mode, which prevents the execution of update or delete commands under non-primary key conditions.

1、show variables like 'SQL_SAFE_UPDATES'; Check the status of the switch.

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

3. Remember to modify it again, SET SQL_SAFE_UPDATES = 1;

Little scum · Posted on 6/24/2023 1:16:16 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] Error Code: 1175. You are using safe update mode and you tried to update a ta...

Related Posts

Sections viewed