how to disable safe mode mysql code example

Example 1: mysql disable safe mode

SET SQL_SAFE_UPDATES = 0;

Example 2: sql disable safe mode

UPDATE tablename SET columnname=1;

Example 3: 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