处理MySQL更新表时Error Code: 1175. You are using safe update mode and you tried to update a table……

分类: IT文章 • 2022-08-02 10:46:32

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