MySQL: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column

 Error message:

You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. 

Solution:

add before the update (/delete) statement:

SET SQL_SAFE_UPDATES=0;