Error Code 1175. You are using safe update mode and you tried to update a table

update fund_nav set nav_chg_rate=left(nav_chg_rate, length(nav_chg_rate)-1) where right(nav_chg_rate, 1) != '%' and nav_chg_rate != ' 0000'    
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 and reconnect.    0.375 sec
 
Solution:
set sql_safe_updates=off;

 1、SET SQL_SAFE_UPDATES = 0;执行该命令更改mysql数据库模式。
 2、在where判断条件中跟上主键id    例如：delete from firstmysqldatabase.user where UserName='zhangsan' and ID>=0;