mysql set safe mode off
snippet in sql

mysql set safe mode off

user1424

SET SQL_SAFE_UPDATES = 0;

sql disable safe mode

user8206

UPDATE tablename SET columnname=1;