在MySQL Workbench中,发出一个简单的删除所有命令
delete FROM users;
但是它显示了以下错误消息:
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.
解
默认情况下,MySQL工作台以安全模式启动,如果没有“ WHERE”条件,则无法更新或删除,请参见错误消息。
要解决此问题,请在菜单中选择“编辑”->“首选项”->“ SQL查询”,然后取消选中“安全更新”复选框。
完成后,尝试重新连接并再次发出delete命令。
标签: MySQL
翻译自: https://mkyong.com/mysql/cant-delete-records-in-mysql-workbench/