MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t (id int auto_increment primary key, x int)
set SQL_SAFE_UPDATES = 1
update t
    set x = 1
You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. 

update t
    set x = 1
    where id > 0