I am trying to update the column visited to give it the value 1. I'm using MySQL workbench, and I'm writing the statement in the SQL editor from inside the workbench.When I'm writing the following command:
UPDATE tablename SET columnname=1;
It gives me the below error:
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 ....
I followed the instructions, and I have also unchecked the safe update option from the Edit menu then Preferences then SQL Editor. The same error still appears & I'm not able to update this value. Please, tell me what's wrong?