safe update mode Mysql code example
Example 1: sql disable safe mode
SET SQL_SAFE_UPDATES = 0;
Example 2: mysql safe mode
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;