how to diable safe update mode in sql 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;