MySQL Release security mode

Question: Rror code:1175. You is using Safe update mode and you tried to update a table without a WHERE that US

Workaround:

Error code:1175. You is using Safe update mode and you tried to update a table without a WHERE is uses a KEY column to disable safe mode , toggle the option in Preferences, SQL Queries and reconnect.

This is because MySQL runs in safe-updates mode, which causes the update or delete command to not be executed under a non-primary key condition. 1, show variables like ' sql_safe_updates '; view switch status. 2. Execute command Set sql_safe_updates = 0; Modify database schema reference: http://jingyan.baidu.com/article/e5c39bf58ed69239d76033a4.html

MySQL Release security mode