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.
Error code: 1175. You are using secure update mode, and you try to update a table that uses key columns without where. To disable safe mode, in preferences – & gt; Switch this option in the SQL editor and reconnect.
Solution: it can be solved with one statement.
SET SQL_SAFE_UPDATES = 0;
After executing the statement, execute the update operation again.