Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.
问题描述:在mysql workbench中对一张包含主键的表进行删除,但是报错,进行测试在命令行和navicat中执行都没有问题,后来发现是workbench对执行命令进行了限制
1. mysql workbench "Edit"-->"Preferences"
2."SQL Editor"-->"Safe Updates"
3.取消勾选
4.重新删除执行成功,重开窗口