MySQL错误:You are using safe update mode and you tried to update a table without a WHERE that uses a K

​

 

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;