[Solved] MySQL Delete or Update Data Error: Error Code: 1175

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.

Because MySQL runs in the safe-updates mode, the update or delete commands cannot be executed under non primary key conditions.

1. show variables like ‘SQL_SAFE_UPDATES’; Check the switch status.

2. Execute command set SET SQL_SAFE_UPDATES = 0; Modify database mode

 

Similar Posts: