disable safe update mode mysql code example
Example 1: sql disable safe mode
SET SQL_SAFE_UPDATES = 0;
Example 2: turn off safe mode mysql
SET SQL_SAFE_UPDATES = 0;
Example 3: sql disable safe mode
UPDATE tablename SET columnname=1;
SET SQL_SAFE_UPDATES = 0;
SET SQL_SAFE_UPDATES = 0;
UPDATE tablename SET columnname=1;