Skip to main content

[Resolved] MySQL error code: 1175 during UPDATE in MySQL Workbench

 If WHERE clause does not have primary key in UPDATE query then this error comes. If you want to run the update query without having primary key in WHERE clause of UPDATE query then below command needs to be run to disable the safe mode.

SET SQL_SAFE_UPDATES = 0;

It is good to run SET SQL_SAFE_UPDATES = 1;  after running your UPDATE query and again enable the safe mode.

Example:

SET SQL_SAFE_UPDATES=0;
UPDATE table_name SET col_name=1;
SET SQL_SAFE_UPDATES=1;

Comments

Popular posts from this blog

Blockchain in Theory - Blockchain, Bitcoin, Mining

   Blockchain is the software protocol that tell the Internet how to transfer money and assets. Blockchain is the layer and Bitcoin is the application. Just one of many cryptocurrency kinds of applications. When one user send email to another then both users do not have to know about the underlaying process except email address. Similarly,  User don't need to know anything other than other user's wallet address to send some bitcoin or other cryptocurrencies.  Any file on Internet may have multiple copies but money is something that should not be copied multiple times. This has been a longstanding problem in computing networks namely the double spend problem. Satoshi Nakamoto introduced white paper for digital cash system in 2008 to resolve the double spending problem and fortified by a ledger which enforces the money is only spent once. It took 15 years alone for corporate email as the main application to be a standard thing in our lives. And similarly the ...

"NodeJS Basics" Theory That You Should Know

To know better about NodeJS, you should know Javascript. So I start with Javascript Javascript is in top 3 language. JavaScript is developed on December 4, 1995. It was a client-side scripting language. So it was used only in browsers. Javascript uses  Javascript engine that is used by browsers to convert code into machine code. We have multiple JavaScript engines just like we have different browsers like Firefox, Chrome, internet explorer, edge etc. First JavaScript engine was SpiderMonkey developed by Netscape Communication by the creator of JavaScript Brendan Eich and it was developed in 10 days. Different browsers are using a different type of Javascript Engine:- Internet Explorer is using Chakra Firefox is using Spidermonkey Chrome is using V8 Microsoft Edge is rebuild using a chromium-based browser and now it is using V8 engine. Most Famous engine is now V8 Javascript engine because it is faster and can be used for mobile development...