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;