1 引言
当更新字段缺少where语句时，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 To disable safe mode, toggle the option in Preferences -> SQL Queries and reconnect. 0.000 sec
2 方案
SET SQL_SAFE_UPDATES = 0; update 表名 set 字段1 = 字段2+1; SET SQL_SAFE_UPDATES = 1;
3 总结
这篇文章仅作为记录使用。