处置MySQL更新表时ErrorCode:1175.You are using safe update mode and you tried to update

处理MySQL更新表时ErrorCode:1175.You are using safe update mode and you tried to update

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 ……;