MySQL Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.

MySQL 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.


SET SQL_SAFE_UPDATES = 0;


Source:

https://stackoverflow.com/questions/11448068/mysql-error-code-1175-during-update-in-mysql-workbench

Comments