Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > Error Code: 1175_MySQL

Error Code: 1175_MySQL

WBOY
Release： 2016-06-01 13:17:49
Original
1193 people have browsed it

用mysql workbench 更新一个表的时候报如下异常：

Error Code: 1175. To disable safe mode, toggle the option in Preferences -> SQL Editor -> Query Editor and reconnect.

You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column

使用安全更新模式的时候update语句必须使用一个关键字列属性来限定更新的范围。如果不使用关键字列来限定范围或更新所有记录的时候就不能用安全更新模式。

解决办法是执行以下语句设置为非安全更新模式.

SET SQL_SAFE_UPDATES=0;
Copy after login
source：php.cn
Previous article：MySQL正则表达式使用――MySQL系列（四）_MySQL Next article：MySQL的C++封装_MySQL
Statement of this Website
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
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
3
2214
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
11
2363
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1975
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1862
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1928
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template