SQL UPDATE statement, Error code:1175. You are using Safe update (encountered when making a view update)

Forwarded on: Http://blog.csdn.net/qq_26684469/article/details/51105188?locationNum=5&fps=1

The original set sql_safe_updates = 1;

If the conditional attributive clause is followed by a non-primary key, the above error will be reported, the above security level is set lower, as follows:

SET sql_safe_updates = 0;

Then execute the UPDATE statement, as

Set sql_safe_updates = 0;update Project.demand Set title= "The hard drive has arrived, who will help me to change the hard drive ah" where title= "intimacy";

Remove null value

Delete from comment where c_content is null

20171206 Update ************************ method

Here's how to fix it:

• Open the Workbench menu [edit]->[preferences ...]
• Switch to the [SQL Editor] page
• Remove the checkmark before [forbid UPDATE and DELETE statements without a WHERE clause (safe updates)]
• Click the [OK] button
• Finally, remember to restart SQL editor and create a new connection.

SQL UPDATE statement, Error code:1175. You are using Safe update (encountered when making a view update)