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

solution 1

SET SQL_SAFE_UPDATES=0;

solution 2

-> Edit -> Preferences -> Sql Editor then uncheck Safe update.

 

posted @ 2020-11-27 12:41  xiluhua  阅读(148)  评论(0编辑  收藏  举报