you tried to update a table without a where that uses a key column code example Example: sql disable safe mode SET SQL_SAFE_UPDATES = 0;