use safe mode mysql code example Example 1: sql disable safe mode SET SQL_SAFE_UPDATES = 0; Example 2: sql disable safe mode UPDATE tablename SET columnname=1;