mysql workbench error - You are using safe update mode - data not updating

Error information :-

 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.

Solution :-

This error because your MySql session has the safe-updates option set. This means that you can't update or delete records without specifying a key (ex. primary key) in the where clause.

Try this above your update query.

SET SQL_SAFE_UPDATES = 0;

update table set column1=0 where column1=1

Or you can modify your query to follow the rule (use primary key in where clause).