MySQL Error code 1175: Safe Update


Example

This error appears while trying to update or delete records without including the WHERE clause that uses the KEY column.

To execute the delete or update anyway - type:

SET SQL_SAFE_UPDATES = 0;

To enable the safe mode again - type:

SET SQL_SAFE_UPDATES = 1;