快速高效用：SET SQL_SAFE_UPDATES = 0；下面的就不要看了！
今日用MySQL Workbench进行数据库的管理更新时，执行一个更新的语句碰到以下错误提示：
Error Code: 1175
You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
进过一番搜索之后发现原来是MySQL Workbench的安全设置。当要执行的SQL语句是进行批量更新或者删除的时候就会提示这个错误。
解决方法如下：
- 打开Workbench的菜单[Edit]->[Preferences...]
- 切换到[SQL Editor]页面
- 把[Forbid UPDATE and DELETE statements without a WHERE clause (safe updates)]之前的对勾去掉
- 点击[OK]按钮
- 最后一步记得要重启一下Workbench，否则你仍然会得到这个错误提示。
相关推荐
You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column 进过一番搜索之后发现原来是MySQL Workbench的安全设置。当要执行的SQL语句是进行批量更新或者删除的时候...
Begin to Code with ...Whether you’re a total beginner or you’ve tried before, Begin to Code with Python will put the power, excitement, and creativity of programming where it belongs: in your hands!
The benefit of a column maker is that it can help you to format your text/code, or in some cases to make it easier to read in complex nested logic. Quick Open UltraEdit and UEStudio provide multiple ...
I have chosen the 10000 number as a good case in both read and writes, you are welcome to tinker with this on your own systems and see what works better for you. Performance Tests v2.3 In v2.3 a ...
If you want to start programming in C# using a tried-and-tested method: download this book now. Table of Contents Chapter 1: Introduction to Programming in C# Chapter 2: Creating your First Script ...
I have tried to create a circular command button like thing (using just shapes).
As you probably know, Android apps utilize code and resources that are found on the Android OS itself. These are known as framework resources and Apktool relies on these to properly decode and build ...
in the demo mode, or the value 1, when the driver has found a valid key, and therefore is licenced. This function is also available via the OPC server interface. The same item-ID address format has...
Because using design patterns will allow you to get your tasks done twice as fast, to write better code and to create efficient and reliable software architecture. How do I become a programming ninja...
I tried some stuff around and when I said require 'firewatir/firefox' , the browser popped up and was good to go. Similarly I had to import the text_field and link elements in order for the tutorial ...
and example data sets that can be run on your personal computer, that are easy to understand, and that illustrate the concepts well. We hope you’ll find this book and the examples useful for ...
主要介绍了Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 2611816 bytes)错误的解决方法,需要的朋友可以参考下
The aim is not to teach LATEX programming, but to give a quick reference to all the tips and tricks that can be used if you are encountering a (difficult) problem, or simply facing a question which ...
iteration (or the only iteration, if you are in testing mode and there is only one iteration), the error file that gives you the average sum squared error value each specified number of iterations,...
If you are keen to learn and have an aptitude for thinking logically, getting a grip on C++ will be easier than you might imagine. By developing C++ skills, you’ll be learning a language that is ...
On the other hand, if you are using Python and wonder what the precise rules about a particular area of the language are, you should definitely be able to find them here. If you would like to see a ...
your access lists are correct, and then shows what to do if you discover that they are wrong. Chapter 6, describes more advanced forms of access lists, including community lists, AS path access ...
It requires attention to details and can be frustrating, but there is very little that compares to the satisfaction of building a program out of nothing and making it work (or taking an existing ...