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;
这就修改好,再执行要修改的sql语句就可以通过。