Error Code 1175. You are using safe update mode and you tried to update a table

Reference：https://stackoverflow.com/questions/11448068/mysql-error-code-1175-during-update-in-mysql-workbench

 

 

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.

 

solution:

SET SQL_SAFE_UPDATES = 0;