set update mode mysql code example

Example 1: sql disable safe mode

SET SQL_SAFE_UPDATES = 0;

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