Error (Error Code: 1175) during executing update command on table using MySQL

update user set name= '**' where account = 'pon' 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 Queries and reconnect. 0.000 sec

 

SET SQL_SAFE_UPDATES=0;

update user set name= '**' where account = 'pon'

posted @ 2013-04-15 11:12  qiangzhu  阅读(311)  评论(0)  编辑  收藏  举报