执行update和delete的SQL语句时，报错：Error Code: 1175. You are using safe update mode and you tried to update a

本文主要是介绍执行update和delete的SQL语句时，报错：Error Code: 1175. You are using safe update mode and you tried to update a，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

执行SQL语句时，报错：
13:36:42 delete from users where username='lisi' 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

解决方法：
执行SQL语句：

SET SQL_SAFE_UPDATES = 0;

output：
13:40:53 SET SQL_SAFE_UPDATES = 0 0 row(s) affected 0.000 sec

这篇关于执行update和delete的SQL语句时，报错：Error Code: 1175. You are using safe update mode and you tried to update a的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---