using safe update mode code example
Example 1: safe update mysql
SET SQL_SAFE_UPDATES = 0;
Example 2: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.
To disable safe update mode
SET SQL_SAFE_UPDATES = 0;
To disable safe update mode