mysql更新字段值提示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
mysql to and 更新 提示 Table Key Using
2023-09-11 14:18:07 时间
1 引言
当更新字段缺少where语句时,mysql会提示一下错误代码:
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. 0.000 sec
2 方案
SET SQL_SAFE_UPDATES = 0; update 表名 set 字段1 = 字段2+1; SET SQL_SAFE_UPDATES = 1;
3 总结
这篇文章仅作为记录使用。
相关文章
- Linux下Apache、PHP、MySQL默认安装路径
- PHP+MySQL无限级分类(非递归)
- 【MySql】MySQL Replication Fatal Error 1236
- 【MySql】mysql 数据库数据订正
- 【Mysql安装】Mac下安装mysql
- linux - mysql 异常:MySQL Daemon failed to start.
- navcat导入mysql.sql出现:2006, 'MySQL server has gone away'
- MySQL按照汉字的拼音排序,mysql汉字排序
- mysql启动时报错:Starting MySQL... ERROR! The server quit without updating PID file (/opt/mysql/data/mysql.pid) 的解决方法
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- 使用mysql-connector-python操作MYSQL数据库
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- 【问题解决方案】MySQL安装后无法启动-net start mysql服务名无效
- Mysql备份还原数据库之mysqldump实例及参数详细说明
- mysql提权总结
- Mysql数据库的mysql Schema 究竟有哪些东西& 手工注入的基础要领
- MySQL技术内幕读书笔记(一)——Mysql体系结构和存储引擎
- MySQL缺失mysql_config文件
- Mysql之加密连接mysql_ssl_rsa_setup
- 【MySql】MySQL数据库--什么是MySQL的回表 ?
- Mycat启动正常但无法连接ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql