your using safe update mode in mysql code example
Example 1: safe update mysql
SET SQL_SAFE_UPDATES = 0;
Example 2: sql disable safe mode
UPDATE tablename SET columnname=1;
SET SQL_SAFE_UPDATES = 0;
UPDATE tablename SET columnname=1;