This article is half-done without your Comment! *** Please share your thoughts via Comment ***
This is a very common error facing by MySQL Database Developer.
Error Code:1175 You are using safe update mode.
That means that you can’t update or delete records without specifying a key (Primary key) in the WHERE clause.
This option is by default ON and if you want to update your records without specifying a key in WHERE clause, you can disable this option at session level or disabled for MySQL workbench.
You can use below script to disable this option at session level.
|
1 |
SET SQL_SAFE_UPDATES = 0; |
Use below steps to uncheck safe update check box.
- Go to Edit -> Preferences.
- Go to SQL Editor tab.
- Uncheck “Safe update” check box.
- Reconnect to your server.
- Do not require to restart MySQL Services.
