Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE tha

问题描述:在mysql workbench中对一张包含主键的表进行删除,但是报错,进行测试在命令行和navicat中执行都没有问题,后来发现是workbench对执行命令进行了限制

Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE tha

 

 

1. mysql workbench "Edit"-->"Preferences"

Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE tha

 

 

2."SQL Editor"-->"Safe Updates" 

Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE tha

 

 

3.取消勾选

Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE tha

 

 

4.重新删除执行成功,重开窗口

Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE tha

 

上一篇:如何在MySQL workbench中建表查询建索引等一系列操作


下一篇:MySql安装与JDBC运行