MySQL updates the table Error Code: 1175 You are using safe update mode and you

Recommended for you: Get network issues from WhatsUp Gold. Not end users.
Error: 1175 SQLSTATE: HY000 (ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE)

Message: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.


Solution:

SET SQL_SAFE_UPDATES = 0;

update T set col = 'xxx' where  condition ……;
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download

Posted by Warren at December 13, 2013 - 10:08 PM