MySQL error code: 1175 during UPDATE in MySQL Workbench

Question

I have been trying to update the column visited to give it the value 1. I use the MySQL workbench, and I'm writing the statement in the SQL editor from inside the workbench. I'm writing the below command:

UPDATE tablename SET columnname=1;

It gave 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 did follow the given instructions, and I also unchecked the safe update option from the Edit menu then Preferences then SQL Editor. The same error still appear & I am not able to update this value. Please, tell me what is wrong? 

Answer 1

It seems like your MySQL session has the safe-updates option set. This means that you cannot update or delete he records without specifying a key (example: primary key) in the where clause.

Try:

SET SQL_SAFE_UPDATES = 0;

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

Interested in SQL ? Check out this Microsoft SQL Server certification by Intellipaat.