disable sql safe update mode code example
Example 1: sql disable safe mode
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;