本文翻译自:MySQL error code: 1175 during UPDATE in MySQL Workbench
I'm trying to update the column visited
to give it the value 1. I use MySQL workbench, and I'm writing the statement in the SQL editor from inside the workbench. 我正在尝试更新visited
的列以赋予它值1.我使用MySQL工作台,并且我在工作台内部在SQL编辑器中编写语句。 I'm writing the following command: 我正在编写以下命令:
UPDATE tablename SET columnname=1;
It gives me the following 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 .... 您正在使用安全更新模式,并且您尝试更新没有使用KEY列的WHERE的表要禁用安全模式,请切换选项....
I followed the instructions, and I unchecke