MySQL错误代码:1175在MySQL Workbench中进行UPDATE期间 [英] MySQL error code: 1175 during UPDATE in MySQL Workbench
问题描述
我正在尝试更新列visited
以为其提供值1.我使用MySQL工作台,并从工作台内部的SQL编辑器中编写语句.我正在编写以下命令:
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. I'm writing the following command:
UPDATE tablename SET columnname=1;
它给了我以下错误:
您使用的是安全更新模式,并且您尝试在不使用表的情况下更新表 使用KEY列的WHERE要禁用安全模式,请切换选项 ....
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 ....
我按照说明进行操作,并且未选中Edit
菜单中的safe update
选项,然后未选中Preferences
,然后未选中SQL Editor
.同样的错误仍然出现&我无法更新此值.拜托,告诉我怎么了?
I followed the instructions, and I unchecked the safe update
option from the Edit
menu then Preferences
then SQL Editor
. The same error still appear & I'm not able to update this value. Please, tell me what is wrong?
推荐答案
我找到了答案.问题是我必须在表名之前加上架构名.即命令应为:
I found the answer. The problem was that I have to precede the table name with the schema name. i.e, the command should be:
UPDATE schemaname.tablename SET columnname=1;
谢谢.
这篇关于MySQL错误代码:1175在MySQL Workbench中进行UPDATE期间的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!