mysql workbench safe update mode code example

Example 1: sql disable safe mode

SET SQL_SAFE_UPDATES = 0;

Example 2: sql safe mode

sql safe mode

Example 3: sql disable safe mode

UPDATE tablename SET columnname=1;

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