-- disable safe update mode SET SQL_SAFE_UPDATES=0; -- execute update statement UPDATE table SET column='value'; -- enable safe update mode SET SQL_SAFE_UPDATES=1;