Mysql workbench problem - Error Code 1175 When update query

Channel:
Ambar Hasbiyatmoko
Subscribers:
4,970
Published on ● Video Link: https://www.youtube.com/watch?v=JPKHHw6o6Iw


Category:
Vlog
Duration: 2:17
28,833 views
249

I get error like this : "Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences - SQL Editor and reconnect."

How to fixing?
- Click Edit Menu
- Preferences
- SQL Editor
- Uncheck Safe Modes
- Restart Mysql Workbench



Other Videos By Ambar Hasbiyatmoko


2016-06-26Centos problem - Another app is currently holding the yum lock; waiting for it to exit
2016-06-09XAMPP1.6.8 (PHP5.2.6) - Cannot modify header information - headers already sent when using system()
2016-06-06Winscp Tutorial - Create FTP website and access it with Winscp
2016-06-02jquery.caret.1.02.js error : Unexpected tokel ILLEGAL and msie undefined
2016-05-29Android problem - The apps cannot read SQlite Database at first time, but second time its works
2016-05-29PHP Tutorial - access (stdClass) Object property named as variable
2016-05-17Postgresql error : column "address" contains null values when trying to add column
2016-04-30Postgresql - Change error message to English or Italian
2016-04-27Java console - How to Connect Java to Mysql from command line (cmd)
2016-04-26Wamp error - localhost & phpmyadmin forbidden on google chrome
2016-04-24Mysql workbench problem - Error Code 1175 When update query
2016-04-24Codeigniter tutorial - Upload file with codeigniter framework on Centos 7
2016-04-23PHP - Display all errors PHP on Ubuntu 14.04
2016-04-22Centos 7 problem - users is not in the sudoers file. This incident will be reported
2016-04-21Install Centos(dvd ISO) and set GNOME Desktop - (virtualbox)
2016-04-20Codeigniter problem - The upload destination folder does not appear to be writable
2016-04-18PHP error - can't use method return value in write context
2016-04-17Pgadmin problem(delete database) - ERROR: database "test" is being accessed by other users (Ubuntu)
2016-04-16Centos 7 - Install php and mysql from terminal
2016-04-15Centos 7 - Install GNOME Desktop in minimal Centos 7 64bit
2016-04-14Centos7 - Enable internet connection in *minimal centos7 64bit


Tags:
mysql
workbench
update
query
error
windows
safe update