sql safe update off code example

Example 1: sql disable safe mode

SET SQL_SAFE_UPDATES = 0;

Example 2: sql disable safe mode

UPDATE tablename SET columnname=1;