MySql解除安全模式:Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.

在修改一条数据字段时报错:

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. 0.000 sec

解决办法步骤:

1:先执行  show variables like 'SQL_SAFE_UPDATES';

2:再执行  SET SQL_SAFE_UPDATES = 0;

MySql解除安全模式:Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.

这就修改好,再执行要修改的sql语句就可以通过。

上一篇:mysql delete数据时报Error Code 1175


下一篇:SQL Server-5种常见的约束