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