Mysql Error Code: 1175. You are using safe update mode and y_MySQL
程序员文章站
2022-06-02 20:25:47
...
Mysql update error:
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有个叫SQL_SAFE_UPDATES的变量,为了数据库更新操作的安全性,此值默认为1,所以才会出现更新失败的情况;
因此可按照如下执行:
方法一:
set SQL_SAFE_UPDATES = 0;
update xxx set xxid = 2;
方法二:
- Go to Edit --> Preferences
- Click "SQL Queries" tab and uncheck "Safe Updates" check box
- Query --> Reconnect to Server
- Now execute your sql query
推荐阅读
-
Mysql Error Code: 1175. You are using safe update mode and y_MySQL
-
MySQL错误:ERROR 1175: You are using safe update mode 解决方法
-
SQL更新语句,Error Code: 1175. You are using safe update(在进行视图更新的时候遇到)
-
MySQL错误:ERROR 1175: You are using safe update mode 解决方法
-
Mysql Error Code: 1175. You are using safe update mode and y_MySQL
-
mysql错误:ERROR 1175: You are using safe update mode 解决方法_MySQL
-
mysql错误:ERROR 1175: You are using safe update mode 解决方法_MySQL
-
ERROR CODE: 1175 YOU ARE USING SAFE UPDATE MODE AN
-
ERROR CODE: 1175 YOU ARE USING SAFE UPDATE MODE AN