Home >Database >Mysql Tutorial >mysql 更新 语句中 的 safe_mode_MySQL
mysql 更新 语句中 的 safe_mode_MySQL
- WBOYOriginal
- 2016-06-01 13:17:301411browse
在mysql5中,可以设置safe mode,比如在一个更新语句中
UPDATE table_name SET bDeleted=0;
执行时会错误,报:
You are using safe update mode and you tried to update a table without a WHERE clause that uses a KEY column.”
原因是在safe mode下,要强制安全点,update只能跟where了,
要取消这个限制,可以:
SET SQL_SAFE_UPDATES=0;
即可
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：数据库外连接和内连接详解_MySQLNext article：Mysql解压版的安装_MySQL