Sometimes your RDBMS does not allow you to do certain changes like updating a table without using a WHERE clause that uses a key column.
When you are really sure what you want to do:
SET SQL_SAFE_UPDATES = 0;
Now the dirty brown magic can begin!
Back to the SQL-Tutorial