sql set safe update code example

Example 1: sql disable safe mode

UPDATE tablename SET columnname=1;

Example 2: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.

To disable safe update mode