缘由: 我在mysql 中,用了以下语句
UPDATE benben.STUDENT SET SAGE = SAGE+1; 时出现了
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Editor -> Query Editor and reconnect.
解决方案:在执行这个语句前加上 SET SQL_SAFE_UPDATES=0; 这一句,即如下
SET SQL_SAFE_UPDATES=0;
UPDATE benben.STUDENT SET SAGE = SAGE+1;
这样就能正常的更新到数据表的数据了... by benben 2012.11.14