Explore an easy way to fix MySQL Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. You can either disable it permanently or turn it off before executing an update/delete statements and turn it back on after. SET SQL_SAFE_UPDATES=0; will fix it for you, but be careful, you are not protected against DELETE FROM table statement anymore.