Posted in mysql

Safe update – MySQL workbench

sometime when we run update / delete in my sql using mysql workbench, we’ll encounter the following:

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 Queries and reconnect. 0.000 sec

Solution:

run the following command:

SET SQL_SAFE_UPDATES = 0;