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

转载自:http://blog.csdn.net/dragonpeng2008/article/details/7279590

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;

上一篇:题解 [USACO Mar08] 奶牛跑步


下一篇:Jenkins实现定时、顺序编译